Updevly
Main content

Excel #VALUE! Error: What It Means and Fixes

By Szabó Gergő · Updated

#VALUE! means Excel received the wrong type of argument, often text where a number was required, or a FIND/MID position that does not exist.

Syntax and arguments

=IFERROR(numeric_formula, 0)
numeric_formula
The math or text function that currently returns #VALUE!.
fallback
Use only after you know the error is an expected blank, not a bad formula.

#VALUE! examples

01
Coerce imported numbers

A2 looks like 12 but is text.

=VALUE(A2)*B2

VALUE converts the text number so multiplication can run.

02
Guard FIND

Needle may be missing from A2.

=IFERROR(MID(A2,FIND("-",A2)+1,10),"")

FIND returns #VALUE! when the hyphen is absent.

03
Subtract dates stored as text

B2 is 2026-01-31 as text.

=DATEVALUE(B2)-A2

DATEVALUE creates a real date before subtraction.

Common mistakes

  • Adding a range with a space instead of a comma or plus

    Check for accidental spaces in the formula bar; they can create #VALUE! or #NULL!.

  • Math on a header row

    Start numeric ranges at the first data row.

  • Hiding every #VALUE! with IFERROR

    Fix types first. Fallback only for known empty inputs.

#VALUE! FAQ

Why does SUMPRODUCT return #VALUE!?

The arrays are different sizes. Align the ranges.

Can a space character cause #VALUE!?

Yes. TRIM and CLEAN imported cells before math.

Does #VALUE! mean the formula is illegal?

It means an argument type or position is illegal for that function, not that Excel crashed.