Result Return for Number and Text Evaluation

[StephenMc1445]

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 · Accepted 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)

[#3]

Awesome! It worked perfectly. Thx so much Hans.