Understanding error messages

IntermediateBeginner

12 questions, about 16 minutes

#VALUE!, #N/A, #DIV/0!, #NAME? and #REF!: what they mean and how to fix them.

What we'll do

  • Recognising the main error codes
  • Finding the cause
  • Fixing an error yourself

What you'll use

  • SUM
  • MIN

How it works

In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.

2examplesYou watch
12questionsYou do it yourself
Full explanation