Dec 16 2021 07:19 AM - edited Dec 16 2021 07:22 AM
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
Dec 16 2021 07:38 AM
SolutionLet'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)
Dec 16 2021 08:31 AM
Dec 16 2021 07:38 AM
SolutionLet'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)