1
Assign a Grade With IFS
Free
A2 holds a numeric score. Write a formula in B2 that returns 'A' for 90+, 'B' for 80+, 'C' for 70+, and 'F' otherwise, using IFS instead of nested IF.
Show the solution
List condition/value pairs in order, ending with TRUE as the fallback: =IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",TRUE,"F")
Right — IFS checks each condition in order and returns the value for the first TRUE one; TRUE as a final catch-all condition acts like an else.
Expected result in B2: A
2
Classify Shipping Cost With IFS
Free
A2 holds an order total. Write a formula in B2 that returns 'Free' for 75+, 'Discounted' for 30+, and 'Standard' otherwise, using IFS.
Show the solution
Use =IFS(A2>=75,"Free",A2>=30,"Discounted",TRUE,"Standard")
Good — IFS reads top-to-bottom like a flatter, more readable alternative to nested IF.
Expected result in B2: Discounted
3
Categorize Age Groups With IFS
Free
A2 holds an age. Write a formula in B2 that returns 'Child' under 13, 'Teen' under 20, and 'Adult' otherwise, using IFS.
Show the solution
Use =IFS(A2<13,"Child",A2<20,"Teen",TRUE,"Adult")
Right — IFS avoids the growing parenthesis-nesting that stacked IFs create.
Expected result in B2: Adult
4
Determine a Risk Level With IFS
A2 holds a risk score. Write a formula in B2 that returns 'High' for 80+, 'Medium' for 50+, and 'Low' otherwise, using IFS.
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →
5
Assign a Late Fee Tier With IFS
A2 holds days overdue. Write a formula in B2 that returns 0 for exactly 0 days, 5 for 7 or fewer days, and 15 otherwise, using IFS.
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →
6
Classify a Test Result With IFS
A2 holds a score. Write a formula in B2 that returns 'Distinction' for 95+, 'Pass' for 50+, and 'Fail' otherwise, using IFS.
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →
7
Determine a Membership Tier With IFS
A2 holds a customer's lifetime spend. Write a formula in B2 that returns 'VIP' for 5000+, 'Regular' for 500+, and 'New' otherwise, using IFS.
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →
8
Categorize Temperature Bands With IFS
A2 holds a temperature. Write a formula in B2 that returns 'Cold' under 50, 'Mild' under 75, and 'Hot' otherwise, using IFS.
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →
9
Assign a Shipping Zone Fee With IFS
A2 holds a distance in miles. Write a formula in B2 that returns 5 under 50 miles, 12 under 200 miles, and 25 otherwise, using IFS.
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →
10
Classify Exam Pass Level With IFS
A2 holds a percentage score. Write a formula in B2 that returns 'Merit' for 85+, 'Pass' for 60+, and 'Fail' otherwise, using IFS.
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →