SOLVED

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,

 

S

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@StephenMc1445 

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

 

=IF(OR(ISNUMBER(SEARCH("BR",C2)),AND(ISNUMBER(C2),C2<E2)),0,1)

Awesome! It worked perfectly. Thx so much Hans.