#N/A, #VALUE!, #REF!, #DIV/0! and #NAME? explained
Read the five common error values, find what causes each one and fix the cause instead of hiding it.
In this lesson
- #N/A, not found: the lookup value isn't in the list. Check for typos and extra spaces.
- #VALUE!, wrong kind of value.
- #DIV/0!, divided by zero: the cell you divide by is 0 or empty.
Try a free lesson first
Delete repeated rows from a merged list, and choose which columns decide what counts as a duplicate.
Confident · 9 min · Free, with no sign-up
Do the free lesson on your computer.
Send yourself the link and open it on a laptop or desktop.
On your computer, go tolearnford.com/go/BV7C
This lesson is in the full Google Sheets course
US$149 once
Tax included. New lessons are added as they're written.
Get the full course, US$14930-day money-back guarantee if you've opened fewer than 10 paid lessons.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- Skill
- Errors and debugging
- Stage
- Confident
- Path
- Reports that don't break
Where it sits in Errors and debugging
- #N/A, #VALUE!, #REF!, #DIV/0! and #NAME? explainedThis lesson11 min
- Why your SUM is wrong10 min
- Circular references8 min
- #SPILL! errors10 min
The steps
13 steps: 3 explanations, 5 Do this, 5 questions, then Your turn.
Try a free lesson first
Delete repeated rows from a merged list, and choose which columns decide what counts as a duplicate.
Confident · 9 min · Free, with no sign-up
Do the free lesson on your computer.
Send yourself the link and open it on a laptop or desktop.
On your computer, go tolearnford.com/go/BV7C