Forum Discussion
How to determine that a value is equal to a scale of values
I need to know how to make that the IF formula understands that the provided value must be greater than, for example, 50 and is equal or less than 100. I tried to use it like this: =IF(50<[cell number]<=100,...). Excel did not output any errors, but all values that were equal to 100 outputed the false value.
What did I do wrong an what should I fix?
2 Replies
The inequality operations only accept two arguments so, to combine them, one may have
= IF(AND(50<testCell, testCell<=100), TRUE, FALSE)(where TRUE and FALSE will be replaced by something more relevant).
