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.
