Exercise catalogue
Choose a category
Pick a topic, then a function. Each exercise opens a real spreadsheet: type the formula, check your answer, and get a hint if you’re stuck.
301 exercises0 completed
Replaces errors.
How IFERROR worksIFERRORIFERROR with Division by ZeroUse IFERROR to replace a divide-by-zero error with a friendly text message.BeginnerNot startedIFERRORIFERROR with VLOOKUP Missing ValueUse IFERROR to show a default when a lookup value is not found.BeginnerNot startedIFERRORIFERROR with Successful DivisionUse IFERROR on a division that succeeds so the normal result is returned.BeginnerNot startedIFERRORIFERROR with Text Instead of NumberUse IFERROR to replace a #VALUE! error caused by arithmetic on text.BeginnerNot startedIFERRORIFERROR with Average of Empty RangeUse IFERROR to handle an error from AVERAGE when no numbers are available.BeginnerNot startedIFERRORSafe Average with IFERRORCombine AVERAGE with IFERROR to handle ranges that contain no numbers.IntermediateNot startedIFERRORNested Lookup with IFERRORUse IFERROR around INDEX/MATCH to return a fallback when a lookup fails.IntermediateNot startedIFERRORSafe Division with IFERRORCalculate price per unit while replacing division-by-zero errors with a custom message.IntermediateNot startedIFERRORLookup with Friendly Not-Found MessageUse VLOOKUP wrapped in IFERROR to return a readable message when a product is missing.IntermediateNot startedIFERRORNumeric Fallback for Missing DataReplace errors from a calculation with a numeric default using IFERROR.IntermediateNot startedIFERRORIndex Match with Fallback TextAn inventory coordinator looks up bin locations by SKU, and unknown SKUs should display 'Not stocked' rather than an error.AdvancedNot startedIFERRORSafe Unit Price LookupA pricing analyst needs the unit price for each order line but some product codes are missing from the price list, so errors must be shown as 0 instead of #N/A.AdvancedNot startedIFERRORDivision with Zero GuardA sales manager computes average deal size per rep, but some reps have zero deals and would cause a #DIV/0! error.AdvancedNot startedIFERRORSafe Percentage of TotalA finance analyst shows each region's share of total sales, but blank or zero totals must not break the report.AdvancedNot startedIFERRORCommission Lookup with Error HandlingA sales manager wants to pull each rep's commission rate from a rate table, showing a fallback message when a rep is missing from the table.AdvancedNot started