#DIV/0! & Safe Division: IF Tests vs IFERROR
This lesson is part of the course
In this lesson
Larkspur Office Supply's product margin report shows #DIV/0! twice. You find the divisor behind each error, repair the margin with an IF test, the growth rate with IFERROR, and check that the average margin is not dragged down by a fake 0%.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- #DIV/0! & Safe Division: IF Tests vs IFERROR Locked
- #N/A from Lookups: Trailing Spaces, Numbers Stored as Text & IFNA Locked
- #VALUE!: Text in Arithmetic, VALUE & SUBSTITUTE Locked
- #REF! & Broken References: Deleted Cells, Relative vs Absolute after Copying Locked
- #NAME? & #NUM!: Typos, Unquoted Text and Impossible Maths Locked
- ISERROR, ISERR, ISNA & ERROR.TYPE: Classify and Count Errors Locked
- Totals That Don't Add Up: Text Numbers, Double Counting & Check Sums Locked
- Model Audit Checklist: Check Cells & Red Flags Locked