Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel RATE Function Not Working? Fix Common ErrorsIf Excel’s RATE function is returning an error or an unexpected number, check that the cash-flow signs are opposite, the payment and…
- PMT Formula Not Working? Fix Excel Payment ErrorsIf your Excel PMT formula is not working, first make the interest rate and number of periods match the payment schedule: monthly…
- Paste Values Not Working in Excel? Causes and FixesIf Paste Values is not working in Excel, copy the source cells again, select the destination, then choose Home > Paste >…
- Excel Not Working? Fix Common Problems Step by StepIf Excel is not working, first identify whether it will not open, has frozen, is showing unexpected results, or cannot save; then…
- Excel OFFSET Formula Not Working? Fix Common ErrorsIf an Excel OFFSET formula is not working, check that its starting reference and row and column offsets point to cells that…
- VLOOKUP Not Working in Excel? Fix the Common CausesIf VLOOKUP returns an error or the wrong result, first check that the lookup value is in the leftmost column of the…
- VLOOKUP Not Working? Fix Common Excel Lookup ErrorsIf VLOOKUP is not working, first check that the lookup value is in the leftmost column of the selected table and add…
- Excel Filter Not Working? How to Find and Fix the CauseIf your Excel filter is not working, first check that the filter covers the entire data range, that the first row contains…
- Why Is My IF Formula Not Working in Excel?If your Excel IF formula is not working, first check its syntax, the cell references, and whether the values being compared are…
- SUMIFS Formula Not Working? Common Causes and FixesIf your SUMIFS formula is not working, first check that its sum range and every criteria range cover the same number of…
- Mode Not Working in Excel? Causes, Checks and FixesIf MODE is not working in Excel, the most common reason is that the selected range contains no repeated numeric values: MODE.SNGL…
- COUNTIFS Formula Not Working? Diagnose and Fix the ErrorsIf COUNTIFS is returning 0, an unexpected count, or an error, check that every criteria range is the same size, then verify…
- Excel MID Formula Not Working? Common Fixes That WorkIf Excel’s MID formula is not working, first check that its starting position and character count are correct: MID counts from the…
- Microsoft Excel VLOOKUP Not Working? Fix Common ErrorsIf Microsoft Excel VLOOKUP is not working, first set its fourth argument to FALSE for an exact match, then confirm that the…
- Microsoft Excel Filter Not Working? Fix Common CausesIf a Microsoft Excel filter is not working, first select a cell in the data and choose Data > Filter, or press…
- Max Function Not Working in Excel? Fix Common CausesIf Excel’s MAX function is returning 0, the wrong value, or an error, first check that the cells you selected contain real…
- MATCH Not Working in Excel? Fix Common Formula ErrorsIf MATCH is not working in Excel, first check the third argument: use 0 for an exact match, and make sure the…
- Excel MATCH Not Working? Fix #N/A and Wrong ResultsIf Excel’s MATCH function returns #N/A or the wrong position, first check its third argument: use 0 for an exact match. With…
- Left and Right Arrow Keys Not Working in Excel?If the left and right arrow keys seem not to work in Excel, first check whether Scroll Lock is on: in Windows,…
- Lookup Value Not Working in Excel? Fix the CauseA lookup value usually fails in Excel because the lookup and source values do not match exactly, the formula uses the wrong…
- Excel Left and Right Mouse Buttons Not Working?If the left or right mouse button is not working in Excel, first check whether the same button works elsewhere; then press…
- LEFT Function Not Working in Excel? Fix ItIf LEFT is not returning the characters you expect, check the formula, the character count, and whether the cell is formatted as…
- LEFT Not Working in Excel? Fix the Common CausesIf LEFT is not working in Excel, first check the formula and the value in its source cell: =LEFT(A2,3) returns the first…
- ISNUMBER Not Working in Excel? Common Causes and FixesIf ISNUMBER is not working in an Excel formula, first check whether the value is really a number: ISNUMBER returns TRUE for…
- IFERROR VLOOKUP Not Working? Find and Fix the ErrorIf IFERROR with VLOOKUP is not working, first check that the formula is structured correctly and that VLOOKUP is searching the intended…
- Excel Formula Not Working? Find and Fix Common ErrorsIf an Excel formula is not working, check that the cell contains a formula rather than text, confirm calculation is set to…
- Hyperlink Formula Not Working in Excel? Fixes That HelpIf an Excel HYPERLINK formula is not working, first check that the cell is not formatted as Text, the formula begins with…
- Hyperlink Function Not Working in Excel? Fix ItIf the HYPERLINK function is not working in Excel, check the formula syntax and the link address first; then confirm Excel is…
- Why Is My Excel Filter Not Working? Causes and FixesAn Excel filter usually fails because the selected range is incomplete, the data has blank or merged headers, or the values are…
- Verizon Cell Phone Not Working? Fixes to TryIf your Verizon cell phone is not working, first check whether Verizon reports a local network problem, then restart the phone and…