Forum Discussion
Solved
Result Return for Number and Text Evaluation
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 ...
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)
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.
