A user wants to print 'Within Budget' in cell B3 if the value in cell A2 is less than or equal to 100, and 'Over Budget' in cell B3 if the value in A2 is greater than 100. Which formula should be typed to achieve these goals?
A=IF(A2<100, "Within Budget", "Over Budget")
B=IF(A2<=100, "Over Budget", "Within Budget")
C=IF(A2<100, "Within Budget", "Over Budget")
D=IF(A2<=100, "Within Budget", "Over Budget") ✓ Correct
Correct answer: (D) =IF(A2<=100, "Within Budget", "Over Budget")
Explanation
The correct formula tests whether A2 is less than or equal to 100 and prints 'Within Budget' if so, else 'Over Budget'.
A form using less than 100 would mark a value of exactly 100 as 'Over Budget', which is wrong.
A form with the less-than-or-equal condition but with the results reversed prints 'Over Budget' when within limit.
Another form repeats the less than 100 error, again mishandling the value 100.
The IF function takes a condition, a true result and a false result.
A value of exactly 100 must count as within budget here.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Practise on Mcqkart →🎓 Book an expert →