Nested IF for three or more outcomes
One IF gives two outcomes. Put an IF inside an IF for three, such as Gold, Silver and Bronze, and get the tests in the right order.
Task 1An IF inside an IF4 questions
One IF gives two outcomes. For three, put a second IF where the value if false would go, which is called a nested IF.
=IF(B2>=10000,"Gold",IF(B2>=5000,"Silver","Bronze"))
The sheet tries the first test, and stops there if it is true. If it is false, it moves on to the second IF.
| A | B | C | |
|---|---|---|---|
| 1 | Rep | Sales | Band |
| 2 | Asha | 12,400.00 | |
| 3 | Ben | 7,900.00 | |
| 4 | Carys | 4,200.00 | |
| 5 | Dev | 10,000.00 |
Task 2The order of the tests matters4 questions