Consider the worksheet below:
|
A |
B |
C |
D |
E |
F |
|
|
1 |
Data |
Result |
||||
|
2 |
-4 |
|||||
|
3 |
||||||
|
4 |
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?
1
=IF (A2 < 100. "Within Budget". "Over Budget")
2
=IF (A2 > = 100. "Over Budget". "Within Budget")
3
=IF (A2 < = 100. "Over Budget". "Within Budget")
4
=IF (A2 < = 100. "Within Budget". "Over Budget")