jeudi 4 juillet 2019

How to shorten a formula with a OR comparing several RIGHT functions in Google Sheets?

I'm trying to solve this problem:

I need to shorten the following formula:

=IFS(
OR(
RIGHT(A1,1)="^",
RIGHT(A1,1)="*",
RIGHT(A1,2)="@@",
RIGHT(A1,2)="%%"),
1,TRUE,0)

I thought of using the pipe symbol like this:

=IFS(
OR(
RIGHT(A1,1)="^|*",
RIGHT(A1,2)="@@|%%"),
1,TRUE,0)

But it's not working.

How to shorten this formula?

Aucun commentaire:

Enregistrer un commentaire