Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Spill Error: Does It Create New Rows?No. Excel’s #SPILL! error does not create worksheet rows; it means a dynamic-array formula cannot place its results in the cells it…
- Excel: Remove #N/A Errors From VLOOKUP Results SafelyTo replace a VLOOKUP #N/A error with a readable message, wrap the lookup in IFNA: =IFNA(VLOOKUP(E2,$A$2:$C$100,3,FALSE),"Not found"). This returns “Not found” when…
- Excel Replace #VALUE! Errors With Blank Cells in FormulasTo show a blank instead of an Excel #VALUE! error, wrap the formula that produces it in IFERROR. For an error already…
- Excel RATE #NUM Error: Causes, Examples, and Fixes ExplainedExcel’s RATE function returns #NUM! when it cannot find a rate that satisfies the cash-flow inputs, often because the values have no…
- Excel REF Error When Pasting: Causes and FixesIf Excel shows #REF! after you paste, a formula has ended up with an invalid cell reference; the paste itself may have…
- Excel: How to Prevent #REF! Errors When Deleting RowsExcel cannot guarantee that formulas will survive deleting the cells they refer to: those references can become #REF!. To avoid that, clear…
- Excel #NAME? Error: Why It Affects Some UsersExcel’s #NAME? error means the formula contains a name, function, or text that Excel cannot identify. If it appears for some users…
- Excel #NULL! Error Fix: Find and Correct Range ReferencesTo fix Excel’s #NULL! error, check for a space between cell ranges: Excel treats that space as an intersection operator, and it…
- Excel #NUM! Error: Causes, Meaning, and How to Fix ItExcel’s #NUM! error means a formula has an invalid numeric value or cannot complete a calculation with the numbers or settings it…
- Excel LAMBDA #VALUE! Error: Causes and FixesAn Excel LAMBDA #VALUE! error usually means the LAMBDA function was called with the wrong number of arguments, or that its calculation…
- Excel LET #NAME? Error: Causes and FixesIn Excel, a LET formula showing #NAME? usually contains a name Excel cannot recognize, or it is being opened in an Excel…
- Excel Invalid Name Error: Causes and FixesIn Excel, an invalid name error usually means a formula contains a name Excel cannot recognize, such as a misspelled function or…
- Excel ISBLANK Not Working With Formula? Fix the CauseExcel’s ISBLANK function returns FALSE when a cell contains a formula, even if that formula displays nothing. If you need to treat…
- Excel IF No Error: Use IFERROR the Right WayTo return a result when an Excel calculation has no error and show an alternative when it does, use =IFERROR(value, value_if_error). For…
- Excel IFERROR: Return a Blank Instead of an Error ValueTo show a blank when an Excel formula returns an error, wrap it in IFERROR and use an empty text string as…
- Excel PivotTable: Hide #DIV/0! Errors Without Fixing DataTo hide #DIV/0! in an Excel PivotTable, select the PivotTable, open PivotTable Analyze > Options, choose the Layout & Format tab, check…
- Excel Formula to Remove the #DIV/0! ErrorIn Excel, the quickest way to replace a #DIV/0! error is to wrap the division in IFERROR, such as =IFERROR(A2/B2,""), which displays…
- Excel #VALUE! Error: Common Causes, Checks, and FixesExcel’s #VALUE! error means a formula received a value or data type it cannot use, such as text where a number is…
- Excel Formula Error Handling: Fix and Prevent ErrorsIn Excel, the quickest way to handle a formula error is to wrap the calculation in IFERROR, which returns a chosen value…
- Excel Formula for Not an Error: ISERROR ExplainedTo check whether a cell does not contain an Excel error, use =NOT(ISERROR(A2)), replacing A2 with the cell you want to test.…
- Excel Formula Spill Error: Causes, Checks, and FixesAn Excel #SPILL! error means a formula is trying to return results into multiple cells, but Excel cannot place the full result…
- Excel FILTER #VALUE! Error: Causes and FixesIn Excel, a FILTER formula usually returns #VALUE! when its include array is not the same height or width as the range…
- Excel Name Already Exists Error: Causes and FixesThe Excel name already exists message usually means the name you are trying to create or bring into a workbook is already…
- Excel #DIV/0! Error: Make the Cell BlankYes. To make a division error show as a blank-looking cell, use =IFERROR(A2/B2,"") when the numerator is in A2 and the denominator…
- Excel COUNTIF Not Working? Fix Formula and Criteria ErrorsIf Excel COUNTIF returns the wrong result, first check that it is looking at the intended cells and that its criterion matches…
- Excel DATEDIF #NUM! Error: Causes, Checks, and FixesExcel’s DATEDIF returns #NUM! most often because its start date is later than its end date; it can also return that error…
- Excel #VALUE! Error: Causes and How to Avoid ItTo avoid Excel’s #VALUE! error, make sure each formula receives the kind of input it expects: numbers for arithmetic, valid dates for…
- Excel Cell Errors: What They Mean and How to Fix ThemAn error in an Excel cell means Excel could not calculate or return the result a formula requests; the error code usually…
- Excel #DIV/0! Error: Causes and FixesExcel’s #DIV/0! error means a formula is trying to divide by zero or by a blank cell. If the value is in…
- Excel #DIV/0! Error: Causes and FixesExcel’s #DIV/0! error means a formula tried to divide a number by zero or by a cell with no usable denominator. Check…