This seems simple, but evidently incorrect. Have any ideas?
The data: Cell J5 value is simply this URL:
www.url.com/at/
The logic: Check if cell J5 ends in "/at/" or if it ends in "de/", value if true for either one of those is 1, value if false for both is zero.
Here's the function I'm trying out: =IF(OR(RIGHT(J5,4)=“/at/"),(RIGHT(J5,3)=“de/"),"1","0")
My result is #NAME?
Aucun commentaire:
Enregistrer un commentaire