#VALUE!

VALUE Error

Occurs when a formula has the wrong type of argument — for example, using text where a number is expected.

Common Causes

1.Using text in a math operation (e.g., adding a cell that contains "N/A" to a number)

2.Spaces or invisible characters in cells that look empty

3.Date formatted as text instead of an actual date value

4.Wrong type of argument passed to a function

Wrap the formula with IFERROR to handle the error gracefully

=IFERROR(A2+B2, 0)

Use VALUE() to convert text to numbers

=VALUE(A2)+B2

Use TRIM() and CLEAN() to remove invisible characters

=TRIM(CLEAN(A2))

Use DATEVALUE() to convert text dates to real dates

=DATEVALUE("01/15/2024")

Have a formula throwing #VALUE!?

Paste your formula for an AI-powered diagnosis specific to your situation.