mercredi 19 juillet 2017

Excel IF and OR formula

My attempt

I'm trying to use the IF statement so that when excel is looking at row A and row B, it'll give the result in Row C.

If the formula scan row A and B, and both A and B is NA, then row C come up to NA.

If A come up as NA, and B come up as Denied, then row C will show up as Denied.

If A come up as reimbursed and B come up as NA, then C will show up as reimbursed.

here's my formula:

=IF(AND(A2 = "NA", B2 = "NA"),"NA",IF(OR(A2="Denied",B2 ="Denied"),"Denied","NA"))

Can I get some tip on how to include "reimbursed" in the formula?

Thanks in advance!

Aucun commentaire:

Enregistrer un commentaire