Logical Functions
Advanced
IFS Function
Use IFS function for multiple conditions without nesting.
Task:
You are calculating shipping costs based on order value, with different thresholds for free shipping and reduced rates. Assign shipping costs based on order value using IFS in column B: >=$200 free, >=$100 $5, >=$50 $10, else $15.
Learning Objectives:
- Learn IFS function
- Understand multiple condition testing without nesting
- Practice advanced logical structures
Hints
Solve without hints for +5 XP
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 | |
|---|---|---|
| 1 | Order Value | Shipping |
| 2 | 25 | |
| 3 | 75 | |
| 4 | 150 | |
| 5 | 300 | |
| 6 | 45 |
What this exercise teaches (contains the answer)
IFS function provides a cleaner alternative to deeply nested IF statements when dealing with multiple conditions.