Excel #VALUE! Error: Causes and Fixes

Errors & fixes · Updated November 20, 2026

In Excel, #VALUE! means a formula received a value or argument it cannot use, often text where a calculation expects a number. Check the formula’s inputs and argument types, then correct the offending value or adjust the formula; the right fix depends on which operation produced the error.

What the #VALUE! Error Means

#VALUE! is one of Excel’s formula error values. It is a signal that Excel could not carry out an operation because the type, shape, or content of a value was unsuitable for that operation. For example, adding a number to a word does not produce a meaningful numeric result, so Excel returns an error rather than guessing what the word means.

The error is not the same as #N/A, which commonly indicates that a lookup did not find a match, or #DIV/0!, which indicates division by zero. It is also different from a formula that returns an incorrect result without showing an error. Seeing #VALUE! narrows the investigation, but it does not identify the exact cell or argument by itself.

Excel may show the error in a cell that depends on another cell containing the original problem. A formula can therefore pass an error along through later calculations. Trace the formula’s references back to their source instead of assuming that the cell displaying the error contains the bad input.

Common Causes

  • Text used in arithmetic: A formula tries to add or subtract a word, label, or other nonnumeric entry as though it were a number.
  • Unexpected spaces or characters: Imported values may include leading or trailing spaces, nonprinting characters, currency symbols, or punctuation that prevents a function from reading the value as intended.
  • Invalid function arguments: A function receives an argument with the wrong type or an invalid value. For example, a text-search function can return #VALUE! when the requested text is not found.
  • Invalid date or time input: A formula or conversion function may be given text that Excel cannot interpret as a date or time in the current settings.
  • Incorrect references or formula construction: A copied formula may point to a label or heading instead of the intended data, or a function may have an argument that does not fit its requirements.
  • Array or range mismatch: Some formulas expect corresponding arrays or ranges to have compatible dimensions. An incompatible set of inputs can prevent the calculation from working as intended.

Do not assume every number that looks unusual is text, or that every text value is a problem. A label in a cell is perfectly valid when a formula is meant to display or compare text. The issue arises when the particular formula operation cannot use that value in that way.

How to Find the Formula or Input Causing It

Start with the cell showing #VALUE!. Select it and read the formula in the formula bar. Identify each referenced cell and each function argument, then inspect the inputs one by one. If the formula is long, temporarily evaluate smaller parts in empty cells, or use Formulas > Evaluate Formula to step through the calculation in Microsoft 365 for Windows.

  1. Check the formula itself. Look for a mistaken operator, an incorrect cell reference, or a function argument in the wrong position.
  2. Inspect the referenced cells. Look for text, blanks, error values, spaces, or values that do not match the formula’s assumptions.
  3. Test the suspect value. Click the cell and examine the formula bar. A value may look numeric but be stored as text; imported data can also contain characters that are hard to see.
  4. Follow dependent formulas. If the inputs to the visible formula look sound, trace upstream cells. A dependent formula may simply be carrying forward an error from an earlier calculation.
  5. Check the function’s documented requirements. Different functions treat text and blank cells differently, so do not apply a general rule to every formula.

For a quick visual check, select a suspicious cell and look for a warning indicator or use the formula bar to see its underlying content. Excel’s error-checking prompts can suggest likely issues, but their suggestions are not a substitute for checking whether the formula matches the intended calculation.

Fixing Text and Number Problems

If a formula expects numeric data, first decide whether the input is supposed to be a number. If it is, convert the source value rather than merely hiding the error. In many cases, selecting the affected cells and using the warning menu’s conversion option will convert numbers stored as text. For a larger import, inspect the import or cleanup process so the problem does not recur.

When a value contains extra spaces, the TRIM function can remove ordinary leading and trailing spaces and reduce repeated internal spaces. With an imported text value in A2, the formula =TRIM(A2) returns a cleaned text value; it does not by itself convert numeric text to a number. If the cleaned content is a valid number, use a separate conversion step when needed.

With a numeric-looking text value in A2, the formula =VALUE(A2) attempts to return the corresponding number. For example, if A2 contains the text 125, the result is the number 125. The conversion can still fail if the text is not recognizable as a number under the workbook’s regional settings, so verify the source format before applying it to a whole column.

Do not remove symbols or punctuation blindly. A comma may be a thousands separator in one data source and a decimal separator in another. Dates and numbers can also be interpreted differently depending on regional settings. Confirm what the source means, then use a consistent format or conversion method.

Examples of #VALUE! in Formulas

Suppose A2 contains the word North and B2 contains 5. With those values in A2 and B2, =A2+B2 returns #VALUE!, because Excel cannot add the word to the number. If A2 is meant to contain a number, replace the text with the intended numeric value. If the formula should combine text and a number for display, use a text-joining approach instead of arithmetic.

A different cause appears with FIND. With the search term cat in A2 and the text Dog in B2, =FIND(A2,B2) returns #VALUE! because FIND cannot locate the requested text. This is not a data-type problem: both inputs are text, but the requested substring is absent. If “not found” is an expected possibility, handle that condition explicitly.

With a value in A2 that may or may not contain the word cat, the formula =IFERROR(FIND("cat",A2),"Not found") returns the position of the match or the text Not found if FIND returns an error. This is useful when absence is a normal outcome, but it should not be used to conceal errors that need investigation.

For instance, with a numeric quantity in A2 and a denominator in B2, =IFERROR(A2/B2,"Check inputs") displays a message when the calculation returns any error. That includes errors beyond #VALUE!. If the only expected issue is a zero denominator, a more targeted check can make the workbook easier to audit. In either case, decide what the message should communicate to someone using the sheet.

Text, Dates, and Imported Data

Imported data is a frequent source of confusing errors because a cell’s appearance does not reveal every character it contains. A pasted value may include a nonbreaking space or another invisible character. TRIM handles ordinary spaces, but it does not remove every possible character from external data. If cleaning does not solve the problem, compare the source value carefully, check the import settings, and use a cleanup method suited to the actual character.

Dates are also stored and interpreted according to Excel’s rules and workbook settings. A date-looking string may be plain text, and a string such as 03/04/2026 can be ambiguous across regional conventions. If a date function returns #VALUE!, check that the source is a valid date in the expected order and that the formula is using a compatible value. Avoid changing date formats alone as a supposed fix: formatting changes how a value is displayed, but does not necessarily convert text into a real date.

For recurring imports, prevention is often better than fixing each error downstream. Check the source file’s column types, delimiters, decimal and date conventions, and unwanted spaces before building calculations on top of it. A small validation step can reveal bad rows early and prevent an error in one source cell from spreading through a report.

When to Use IFERROR—and When Not To

IFERROR replaces any error in its first argument with a value you choose. It is appropriate when an error is an expected outcome and the replacement is informative, such as showing “Not found” for an optional search. It can also make a report cleaner when a calculation is intentionally unavailable for some rows.

However, IFERROR can hide mistakes in formulas, references, or source data. A formula that should return a number might silently show a blank because a referenced cell contains unexpected text. During troubleshooting, remove or bypass error handling so the underlying error is visible. After fixing the cause, add error handling only if it represents a deliberate business rule, and choose a message that does not suggest a valid numeric result where none exists.

If a workbook is shared, document what the fallback means. A blank can be mistaken for zero, and a message such as “Check inputs” may be more useful than suppressing the error entirely. Error handling should improve interpretation, not make the workbook appear correct when its inputs are not.

Preventing the Error in Future Workbooks

Reliable spreadsheets make their assumptions visible. Use clear headers, keep raw imported data separate from cleaned data, and avoid mixing labels and numbers in a column that is meant to contain only numeric values. Where appropriate, use data validation to limit entries, and check imported data before calculations depend on it.

  • Apply a consistent data type to each column and verify imported values before using them in formulas.
  • Use explicit references and check copied formulas for references that shifted unexpectedly.
  • Test formulas with ordinary inputs and edge cases, including missing text, unexpected labels, and blank cells.
  • Keep source values intact when cleaning data, so the original input can be reviewed if a conversion gives an unexpected result.
  • Use IFERROR only for known, acceptable error conditions, and make the fallback meaning clear.

These steps are especially useful in workbooks maintained by several people. A clear input area and a separate calculation area make it easier to tell whether the issue is a bad entry, a conversion problem, or a formula that needs correction.

Frequently Asked Questions

What does #VALUE! mean in Excel?
It means Excel could not evaluate a formula because a value or argument was unsuitable for the operation. Common causes include incompatible text and number inputs, invalid function arguments, and text that a function cannot find or interpret.

How do I fix #VALUE! in Excel?
Select the cell, inspect its formula and referenced cells, and identify the input or argument that does not fit the calculation. Correct the source value, convert text when appropriate, or revise the formula to handle the expected case.

Why does Excel show #VALUE! when adding numbers?
One of the referenced cells may contain nonnumeric text, an unexpected character, or a value stored in a form the calculation cannot use. Check the underlying cell contents rather than relying only on how they appear in the worksheet.

Can spaces cause a #VALUE! error?
Yes, spaces or hidden characters can interfere with a conversion or text operation. TRIM can remove ordinary extra spaces, but some imported characters require a different cleanup method. Check the source before changing data.

Does IFERROR fix the cause of #VALUE!?
No. IFERROR replaces an error result with a chosen value or message; it does not correct the formula or input that caused the error. Use it for expected error cases, and investigate first when the underlying problem may indicate bad data or a mistake.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.