Question

Given the formula

=IF(A1<10, "low", IF(A1<20, "middle", "high"))
If the value of A1 is 10, what will the formula return?

Answer 1

Answer: middle.

Explanation: It is not less than 10, so won't return low. It is less than 20, so answer is middle. If it were 20 or more

it would return the alternate "high"