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...
=IF(AND(A1>3,A1<10),"A","B")
This works in my sheet if the value is entered in cell A1.
This works in my sheet if the value is entered in cell A1.
Thanks Oliver. Appreciate your response. That works on my sheet too.