Determining If a Value Is Outside of a Given Range and Flag a Cell If True in Excel 2010
Posted on 2013-12-13
I have a user who wants to have value compared two values that determine a range. If the value is greater than or less than the range between the two other values. He would like to flag an entirely different cell than the one containing the formula.
Here is a clearer example of the logic:
Logic hoping to achieve
If (O4) is less than (E4) OR (O4) is greater than (F4) then (O63),“R”
Incorrect Excel function
=IF (O4) < (E4) OR > (F4),(O63,”R”)