Lab › Fixes & Errors
Fixes & Errors: Excel Lab
Make #DIV/0! and #N/A disappear the right way. Pick a lab. Watch how, then do it yourself.
LAB 21Beginner
Fix #DIV/0! with IFERROR
Average sale per order = Sales ÷ Orders. People with 0 orders give #DIV/0!. Show 0 instead.
IFERROR, DivisionOpen lab →
LAB 22Intermediate
Fix #N/A: Code Not Found
Look up each product's price. Some codes are not in the price list; show 'Not found' and an amount of 0.
VLOOKUP (exact match), IFERROROpen lab →
