Combination of operator OR & AND in Excel formula

[Dahlia]

Dear Excel Experts,

Please help me to understand. I have the below formula. I coded with understanding that:-

1. If in E2 meet the first condition, which is the value is "terminated", then automatically return result "Yes".
2. If E2 value is not "terminated", then moves on to the next part, which is if E2 value is "suspended" and at the same time A2 value matches one of the values in the range, it will still return "Yes", else "".

Correct me if I am wrong, if above statements are correct, why is my formula below still return error even the E2 value is "terminated"?


=IF(OR(E3="terminated",AND(E3="suspended",MATCH(A3,$K$2:$K$28,0))),"Yes","")



Appreciate your help.


Thank you so much.
DZ

[loginjmor]

Hi -

It's hard to say for sure without a sample spreadsheet. Perhaps you could upload one with sample data? One problem might be that the MATCH function will return a relative position within the array $K$2:$K$28. So you could get a number like 3 or 8 or something. Making that result part of an AND statement, which is comparing TRUE and FALSE, not 3 or 8, could be part of your problem.