Course
Nested IF and IFS practice exercises
Five exercises, from a first nested IF to IFS with AND, including a formula with its conditions in the wrong order to fix. Each answer is checked instantly.
Read the nested IF and IFS tutorial
Exercise 1 of 5
Shipping fee with nested IF
Shipping costs 5 up to 1 kg, 9 up to 5 kg, and 15 above that. Fill C2:C6 with a nested IF.
| Order | Weight (kg) | Shipping ($) |
| SO-2051 | 0.8 | |
| SO-2052 | 3.5 | |
| SO-2053 | 12 | |
| SO-2054 | 1 | |
| SO-2055 | 5 |