dimanche 3 janvier 2021

Nested AND/OR IF functions for excel

=IF(AND(E4=F4, OR(E4="YES", F4="YES")), "Yes", IF(OR(E4="MAYBE",F4="MAYBE"),"Maybe","No"),"No")

Does anyone know how to fix this for excel? I have tried many things that aren't working. I am essentially trying to say : If both cells are equal to each other and are yes, then yes, if one cell has a maybe then maybe, else no.

Aucun commentaire:

Enregistrer un commentaire