Result Return for Number and Text Evaluation

New Contributor

I have a cell that needs to return a value of "0" if an adjacent cell has 2 conditions - it includes the text "BR" and it is a numerical value that is below an amount in another cell - otherwise, if neither of these 2 conditions are met, then it should return a value of "1".


So far, I cannot figure out how to write the formula to accomplish this double-check. I've tried both an IF + IF formula and a IF(AND) formula, but so far, no luck. Any suggestions?


Thanks in advance,



2 Replies
best response confirmed by Sergei Baklan (MVP)


Let's say the adjacent cell is C2 and the other cell is E2.



Awesome! It worked perfectly. Thx so much Hans.