#REF! & Broken References: Deleted Cells, Relative vs Absolute after Copying
This lesson is part of the subscription
The first 2 lessons of this course are free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- #DIV/0! & Safe Division: IF Tests vs IFERRORFree
- #N/A from Lookups: Trailing Spaces, Numbers Stored as Text & IFNAFree
- #VALUE!: Text in Arithmetic, VALUE & SUBSTITUTE Pro
- #REF! & Broken References: Deleted Cells, Relative vs Absolute after Copying Pro
- #NAME? & #NUM!: Typos, Unquoted Text and Impossible Maths Pro
- ISERROR, ISERR, ISNA & ERROR.TYPE: Classify and Count Errors Pro
- Totals That Don't Add Up: Text Numbers, Double Counting & Check Sums Pro
- Model Audit Checklist: Check Cells & Red Flags Pro