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”)