Excel shows the #VALUE! error

Possible solutions

Choose the method that matches your situation. Start with the simplest suitable option and check the result. If the problem is fixed, you do not need to continue with the other methods.

1. Processing of input data

   Check that the formula receives numbers instead of text and remove unnecessary spaces.

   Steps to follow

   1. Select the cell used in the formula and check that it is indeed a number and not text with a space or unit word.
   2. Try a small copy: enter a real number and compare the result. Do not blindly rewrite the original table.
   3. Check the decimal tab with your Excel language and data form; only then handle the affected cells.

2. Checking the parts of the formula

   Check part by part and compare tabs; IFERROR must not replace correcting the real cause.

   Steps to follow

   1. Make a copy of the table and mark the wrong formula in it.
   2. Check its links and the result of each part; if the version has Formula > Evaluate Formula, use preview.
   3. If you find text instead of a number or an invalid link, correct it and check the result. Use IFERROR only to understand the cause, not to hide the error.