=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