IF
Do one thing when true, another when false
0 of 3 done · Lesson 4 of 18
Understand
Finance wants anything over a thousand dollars flagged for a second look. You could read down the column and type the flags yourself. IF writes the rule down once, and the rule keeps applying after you have gone home.
=IF(what to check, if it is true, if it is false, optional)
A worked example
=IF(D5 > 1000, "Review", "Fine")
what to checkif it is trueif it is false
D5 is 560, so this returns Fine
The sheet you are working with
| Row number | A | B | C | D |
|---|---|---|---|---|
| 1 | Order | Customer | Region | Amount |
| 2 | 1042 | Northwind | Otago | 1250 |
| 3 | 1043 | Kea Ltd | Waikato | 840 |
| 4 | 1044 | Halcyon | Otago | 2110 |
| 5 | 1045 | Brightsmith | Auckland | 560 |
| 6 | 1046 | Tuatara | Waikato | 1780 |
| 7 | 1047 | Fernway | Otago | 930 |
| 8 | 1048 | Pounamu | Nelson | 1420 |
| 9 | 1049 | Rimu Co | Otago | 670 |