CODEWITHSUNDEEP
vbaexcelif-statement
Kevin
Kevin

Reputation: 3

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!

Upvotes: 0

Views: 84

Answers (1)

Jace J McPherson
Jace J McPherson

Reputation: 450

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

Upvotes: 3

Related Questions