UGC NET ICT Q29

Question

Consider the worksheet below:

[Table with A, B, C, D, E, F columns and Data, Result rows]

If a user wants to do the following:
(i) Print "Within Budget" in cell B3 if the value in cell A2 is less than or equal to 100.
(ii) Print "Over Budget" in cell B3 if the value in cell A2 is greater than 100: then what formula would the user have to type in order to achieve the above stated goals?

Accepted Answer

IF (A2<=100, "Over Budget", "Within Budget")