IF against another cell
Each row carries its own threshold; compare to the cell, not a typed number.
Task:
Each item has its own reorder level. In D2:D6 show Reorder when stock on hand is at or below that item's level, otherwise OK.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of IF
0/4The same formula in the other shapes it takes at work.
- Basic IF Function
Make the sheet decide, instead of deciding row by row yourself.
CoreIntermediate - IF that returns a calculation
The answer to an IF can be a sum, not just a word.
Intermediate - IF for an empty cell
Test for "" before calculating with a cell that might not be filled in yet.
Intermediate - IF against another cell
Each row carries its own threshold; compare to the cell, not a typed number.
Beginner
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | On hand | Reorder level | Action |
| 2 | Gloves (box) | 14 | 20 | |
| 3 | Masks (box) | 45 | 30 | |
| 4 | Wipes | 12 | 12 | |
| 5 | Gel (1L) | 8 | 10 | |
| 6 | Aprons | 60 | 25 |
What this exercise teachesMay contain the answer
Typing the threshold into the formula only works when every row shares it. Pointing at C2 lets each item carry its own level, and when purchasing changes one, the action column follows without anybody editing a formula.