Logic & conditional functions
Practice IF, nested IF, IFS, and multi-condition decision logic used in real business spreadsheets.
Exercises in this track
Pass or fail with IF
Use the IF function to determine whether students passed or failed based on their scores.
IF with numeric output
Calculate a 10% bonus if sales exceed target, otherwise 0.
Simple IF statement
Categorize sales as "On target" or "Below target" based on a threshold.
Basic AND function
Check if a sale meets BOTH minimum quantity AND minimum value thresholds.
Flag overdue invoices with IF and NOT
Use IF combined with NOT to flag overdue invoices that are not marked as paid.
Practicing and, or, and if
This one's an opportunity to practice your IFs, ANDs and ORs. You may find yourself combining these functions when you require more complex...
Nested IF for grading
Assign letter grades (A, B, C, D, F) based on numerical scores.
Nested IF for commission tiers
Calculate sales commission using a 3-tier rate structure.
Assign shipping methods with IFS
Assign shipping method based on package weight using IFS.
SWITCH for department budget codes
Use SWITCH to translate department codes into full names and budget categories in a quarterly budget review report.
Basic Iferror exercise
In this exercise, we're looking at the Iferror function. This function can be handy when you expect errors to exist, but you want to handle them...
Creating an IFNOTERROR function
Excel contains an IFERROR function that will return a different value if an error is given. But it does not contain an IFNOTERROR function that will...