Can't remove #VALUE! from excel sheet

Mithun Das 0 Reputation points
2026-09-13T14:06:00.33+00:00

User's image

#VALUE! is not going

Microsoft 365 and Office | Excel | For business | Windows

3 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-09-13T14:06:21.47+00:00

    #VALUE! usually means the formula is referring to text, spaces, or hidden characters instead of clean numeric values.

    Try this in order:

    1. Select the cell that shows #VALUE!.
    2. Go to Formulas > Evaluate Formula > Evaluate.
      • This shows which part of the formula is failing.
      • If one referenced cell contains a hidden space or text, Excel will stop there.

    Then clean the referenced cells:

    1. Select the cells used by that formula.
    2. Go to Home > Find & Select > Replace.
    3. In Find what, type one space.
    4. In Replace with, leave it empty.
    5. Select Replace All.

    If the error remains, check for hidden non-space characters:

    1. Turn on a filter with Home > Sort & Filter > Filter.
    2. Open the filter arrow, clear Select all, then select Blanks.
    3. Select any blank-looking cells or unnamed checkboxes that appear, then press Delete.
    4. Clear the filter.

    If a cell looks numeric but is actually text, retype that value, or use CLEAN or REPLACE, then copy the result and use Home > Paste > Paste Special > Values.

    If the formula is using operators like + or *, and some referenced cells may contain text, use functions instead where possible:

    • Instead of =A2+B2+C2, use =SUM(A2:C2)
    • Instead of =A2*B2, use =PRODUCT(A2,B2)

    If only the display needs to hide the error, IFERROR can replace #VALUE!, but this only hides the problem and does not fix it.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Mithun Das 0 Reputation points
    2026-09-13T14:14:11.97+00:00

    [Moderator note: Personally Identifiable Information removed]

    Was this answer helpful?

  3. Heimerdinger 375 Reputation points Independent Advisor
    2026-09-13T14:21:50.5533333+00:00

    Hello Mithun Das,

    The #VALUE! error normally means that the formula contains an invalid argument or references a cell containing text, spaces, or hidden characters instead of a numeric value. This usually means that the FeO formula has an incorrect reference or one of the referenced values is stored as text or contains a hidden space.

    You could refer to this article : How to correct a #VALUE! error | Microsoft Support

    Please select the FeO error cell and:

    • Share the complete formula displayed in the Formula Bar.
    • Select Formulas > Evaluate Formula to locate the part causing the error.
    • Confirm that 10.3 and 11.51 are stored as numbers.
    • Compare the formula with the working CaO formula directly below it.

    Could you please select the FeO cell showing #VALUE! and provide a screenshot of the full formula displayed in the Formula Bar?

    Please also show the formulas from the corresponding working cells, such as the CaO or SiO2 result cells, so the formulas and cell references can be compared. This will help determine whether the FeO formula contains an incorrect reference, different calculation, or text value.

    With this information, I can help investigate the issue further and suggest the most appropriate troubleshooting steps.

    Thank you again for your time and understanding. I really appreciate your patience, and I’m here to help. Looking forward to your response.                 

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.