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 numbe...
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).