Forum Discussion
Excel problem
I am trying to use an IF formula to tell me if a number is greater than and less than two numbers. For example: minimum number is 3, maximum number is 10. Question is, is 7 between these two numbers...
Your formula determines that 7>3 and returns "A". It never looks as the 10.
A variant that I like is
= IF(XOR(A1<{3,10}), "A", "B")which evaluates an array of two Booleans and then determines whether only one is true.
Thanks for your response Peter. The formula worked good. I must learn more about the different brackets.