Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 3/4

#VALUE! and #NAME?

Exercise 1 of 4

D2 adds January and February and shows #VALUE!. Why?

About this lesson

#VALUE! means the formula got the wrong kind of value, such as text where it needs a number. #NAME? means Excel doesn't recognise a word in the formula: a misspelled function, or text without quotes.

In this lesson

  1. D2 adds January and February and shows #VALUE!. Why?
  2. February's figure for the North is still pending. Fix D2 so it adds the two months and skips the text.
  3. E2 should add up all the amounts but shows #NAME?. Find the typo and fix the formula.
  4. E2 should say "yes" when the first order is from the North, but shows #NAME?. Fix the formula.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Try it out: type a formula in any free cell or change a value. What you type on the sheet isn’t graded.