mercredi 21 octobre 2015

If OR with RIGHT in Excel

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