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