Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problemsSome links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
Excel formulas usually fail in one of five ways: Excel is displaying the formula as text, calculation is set to Manual, the syntax or reference is invalid, the formula returns an error, or it calculates a logically wrong result. Start by selecting the cell and checking the Formula Bar, then follow the symptom-specific fix below.
- Confirm the entry begins with
=. - Check whether Formulas > Show Formulas is enabled.
- If the formula is text, change the cell format to General and press F2, then Enter.
- Set calculation to Automatic and press F9.
- Read any displayed error code before changing the formula.
First identify what “not working” means
The fastest diagnosis depends on the symptom:
- You see
=SUM(A1:A10)in the cell: Show Formulas may be on, or the cell contains text. - The old answer remains after inputs change: Calculation may be Manual.
- Excel says “There’s a problem with this formula”: Check syntax, separators, quotes and references.
- An error code appears: Use the code-specific table below.
- A number appears but is wrong: Inspect ranges, copied references, data types and lookup logic.
- It works in one file or device but not another: Check links, feature support and the Excel edition.
If Excel displays the formula instead of its result
Turn off Show Formulas
If every formula on the worksheet is visible, choose Formulas > Show Formulas. On supported desktop and web versions, Ctrl + ` toggles the same display; the grave-accent key is usually near the top-left of the keyboard. This changes the view—it does not convert formulas into text. See Microsoft’s instructions for displaying or hiding formulas.
Convert a text-formatted cell back to a formula
A cell formatted as Text, or a formula preceded by an apostrophe such as '=SUM(A1:A10), is treated as characters. Select the cells, choose Home > Number Format > General (or another appropriate numeric format), then press F2 and Enter to re-enter each formula. Changing the format alone may not recalculate an existing text string. For a suitable range, Data > Text to Columns > Finish can force bulk re-entry; make a copy first if the range contains mixed data.
Check the entry itself
Every formula must start with =. For example, =SUM(A1:A10) is a formula, while SUM(A1:A10) is text or an ordinary entry. Also check that the formula was not pasted with a leading apostrophe.
#1 Best Overall
- Reliable Plug and Play: The USB receiver provides a reliable wireless connection up to 33 ft (1), so you can forget about drop-outs and delays and you can take it wherever you use your computer
- Type in Comfort: The design of this keyboard creates a comfortable typing experience thanks to the low-profile, quiet keys and standard layout with full-size F-keys, number pad, and arrow keys
- Durable and Resilient: This full-size wireless keyboard features a spill-resistant design (2), durable keys and sturdy tilt legs with adjustable height
- Long Battery Life: MK270 combo features a 36-month keyboard and 12-month mouse battery life (3), along with on/off switches allowing you to go months without the hassle of changing batteries
- Easy to Use: This wireless keyboard and mouse combo features 8 multimedia hotkeys for instant access to the Internet, email, play/pause, and volume so you can easily check out your favorite sites
If the result does not update
Set calculation to Automatic
In Windows desktop Excel, open File > Options > Formulas, select Automatic under Calculation options, and confirm. Calculation settings can affect open workbooks, so a file copied from someone else may retain Manual mode. Microsoft documents the setting and iteration controls at formula recalculation and iteration.
Recalculate at the appropriate level
- F9: recalculates changed formulas and their dependents.
- Shift + F9: recalculates the active worksheet.
- Ctrl + Alt + F9: recalculates all open workbooks.
- Ctrl + Alt + Shift + F9: rebuilds the dependency tree and recalculates where supported.
Shortcut availability and behavior vary between Windows, Mac, web and mobile editions. Recalculation cannot repair invalid syntax, broken references or incorrect logic.
Fix syntax and reference mistakes
Microsoft lists missing equal signs, incorrect operators, missing quotation marks, unmatched parentheses and missing arguments among common causes of broken formulas. Compare the formula with these patterns:
Rank #2
- 【Ergonomic Wireless Keyboard Mouse 】: Wireless ergonomic keyboard is equipped with adjustable height tilt legs to increase comfort and prevent your wrists injury when typing for a long time. The full size wireless keyboard with numeric keypad and 12 multimedia shortcut keys, such as play/ pause, volume increase and decrease, and email, to help you improve work efficiency
- 【Stable & Reliable Wireless Connection】: This wireless keyboard and mouse combo share the same USB receiver(stored in the mouse), and they can also be used separately. Plug & play, no need to download any software, 2.4 GHz wireless provides a powerful and reliable connection up to 33 feet(10m) without any delays.You can enjoy the convenience and freedom of wireless connection at home or at work
- 【Comfortable Optical Mouse】: This compact lightweight wireless mouse features a hand-friendly contoured shape for all-day comfort, and smooth, precise tracking.1600 DPI to meet your daily needs. Perfect for home & office work and entertainment
- 【Long Battery Life】: Up to 365 Days of battery life for keyboard and mouse wireless, say goodbye to the hassle of charging cables and replacing batteries. After 10 minutes of inactivity, the wireless keyboard mouse combo will automatically go into sleep mode to save energy. The wireless keyboard requires one AAA battery, and the wireless mouse requires one AA battery.
- 【Less Noise, More Quiet Keys】: Soft membrane keys provide a quiet and comfortable typing experience, So you can type with confidence on a wireless keyboard crafted for comfort, precision and fluidity. The wireless mouse adopts silent micro-motion technology, which is almost completely silent when clicked. No more concerns about disturbing others.
| Problem | Incorrect | Correct |
|---|---|---|
| Missing equal sign | SUM(A1:A10) |
=SUM(A1:A10) |
| Text without quotes | =IF(A1>10,Over Budget,OK) |
=IF(A1>10,"Over Budget","OK") |
| Wrong multiplication operator | =A1xB1 |
=A1*B1 |
| Unmatched parentheses | =IF(A1>10,SUM(B1:B5) |
=IF(A1>10,SUM(B1:B5),0) |
| Sheet name containing spaces | =SUM(Sales Report!A1:A8) |
=SUM('Sales Report'!A1:A8) |
Argument separators follow regional settings. Your Excel may require commas, as in =IF(A1>10,"Yes","No"), or semicolons, as in =IF(A1>10;"Yes";"No"). Check the function tooltip or a working formula in the same installation. A misspelled function, missing required argument or unavailable function can also produce an error.
For more syntax examples, see Microsoft’s broken-formula guidance and its Mac formula-error guidance.
What Excel error codes mean
| Error | Likely cause and check | Repair or caution |
|---|---|---|
#N/A |
A lookup or match cannot find the requested value. Check the lookup range, exact versus approximate match, hidden spaces and text-versus-number keys. | Use IFNA(XLOOKUP(A2,Products[ID],Products[Price]),"Not found") when absence is expected. See Microsoft’s #N/A guidance. |
#VALUE! |
Excel received an incompatible type, such as text where arithmetic expects a number, a text date or imported spaces. | Test with ISNUMBER, ISTEXT and VALUE; try TRIM(CLEAN(A1)). Non-breaking spaces may require SUBSTITUTE. |
#REF! |
A referenced row, column, cell or workbook is invalid, often after deletion or a moved source file. | Restore or repair the reference. See Microsoft’s #REF! guidance. |
#DIV/0! |
The divisor is zero or blank. | Use =IF(B2=0,"No denominator",A2/B2). IFERROR can hide a real data problem, so do not use it as the first repair. |
#NAME? |
A function, named range or text literal is misspelled; a required add-in or newer function may also be unavailable. | Check spelling, quotation marks and version support. For example, use "High", not High, as text. |
#NUM! |
An impossible or unsupported numeric calculation, invalid argument or out-of-range value. | Check signs, dates, iteration and numeric inputs; use 1000, not $1,000, as an arithmetic argument. |
#CALC! |
A calculation-engine limitation, often involving dynamic arrays, nested arrays or unsupported custom-function scenarios. | Restructure the formula or test it in compatible desktop Excel. See Microsoft’s #CALC! guidance. |
#SPILL! |
A dynamic-array result cannot occupy its intended range because cells are occupied, merged, outside the sheet, or restricted by the formula’s context. | Select the error indicator, inspect the highlighted spill range, and clear or move blocking cells. |
When the formula calculates but the answer is wrong
Check references after copying
Relative references change when filled. Use $A$1 for a fully fixed reference, $A1 to fix the column, or A$1 to fix the row. Compare the Formula Bar with the rows above and below for a missing $, a total row that includes itself, or a range that ends one row early.
Rank #3
- Dependable wireless connection: Enjoy the reliability and convenience of 2.4 GHz connectivity with your logitech wireless keyboard and mouse combo, wireless range up to 10 meters away at home, or work.
- Full-Size Wireless Keyboard: Comfortable, quiet typing on a familiar keyboard layout with palm rest, spill-resistant design, and media keys. This wireless keyboard and mouse logitech has easy-access to media keys
- Plug and Play: MK345 works seamlessly with Windows, macOS, and ChromeOS. Experience hassle-free setup with the logitech mk345 wireless combo and wireless keyboard mouse combo for various operating systems.
- Long-lasting Battery: The MK345 combo offers a full size keyboard battery life of up to 3 years and a mouse battery life of 18 months (1); batteries included
- Comfortable Right-handed Mouse: This wireless USB mouse with dongle works well for this wireless mouse and keyboard combo, featuring a contoured shape for all-day comfort and smooth, precise tracking and scrolling for easier navigation.
Validate data types and dates
Numbers stored as text can look identical to numbers but behave differently. Test a suspect cell with =ISNUMBER(A2), =ISTEXT(A2) and =LEN(A2). Imported spaces, nonprinting characters and dates interpreted under the wrong regional format can alter comparisons and arithmetic.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →Audit lookups, tables and ranges
Confirm that the lookup value exists, the return range aligns with it, and exact matching is selected when required. Check that newly added rows are included. Excel Tables use structured references such as =SUM(DeptSales[Sales Amount]); they generally expand with table data, but linked-workbook support for some structured references is limited. Microsoft explains the syntax at structured references with Excel Tables.
Hidden rows, filters and formulas returning "" can also change what you see. An empty string is not the same as a genuinely blank cell. For inconsistent copied formulas, use Microsoft’s inconsistent-formula guidance.
Rank #4
- Reliable Plug and Play: The USB receiver provides a reliable wireless connection up to 33 ft (1), so you can forget about drop-outs and delays and you can take it wherever you use your computer
- Type in Comfort: The design of this keyboard creates a comfortable typing experience thanks to the low-profile, quiet keys and standard layout with full-size F-keys, number pad, and arrow keys
- Durable and Resilient: This full-size wireless keyboard features a spill-resistant design (2), durable keys and sturdy tilt legs with adjustable height
- Long Battery Life: MK270 combo features a 36-month keyboard and 12-month mouse battery life (3), along with on/off switches allowing you to go months without the hassle of changing batteries
- Easy to Use: This wireless keyboard and mouse combo features 8 multimedia hotkeys for instant access to the Internet, email, play/pause, and volume so you can easily check out your favorite sites
Find and remove circular references
A circular reference occurs when a formula points to itself directly or through another cell—for example, entering =A1+A2 in A1, or =SUM(A1:F1) in F1. On desktop Excel, choose Formulas > Error Checking > Circular References, select each listed cell, and edit the formula. Use Trace Precedents and Trace Dependents to locate indirect loops. Continue until the status bar no longer reports circular references. Microsoft’s workflow is documented at remove or allow a circular reference.
Some financial models intentionally use iteration. Windows exposes it at File > Options > Formulas > Enable iterative calculation; Mac uses Excel > Preferences > Calculation > Use iterative calculation. Set Maximum Iterations and Maximum Change deliberately. Microsoft lists defaults of 100 iterations or a change smaller than 0.001; workbook settings and versions can differ. Enabling iteration is not a substitute for removing an accidental loop.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Repair worksheet and workbook links
References to another worksheet
A sheet name containing spaces must be enclosed in single quotes: =SUM('Sales Report'!A1:A8). Without the quotes, Excel may reject the formula or interpret the reference incorrectly.
Best Value
- 【Lag-free & Efficient】Stable and reliable connection of wireless keyboard and mouse is up to 10m(33ft). This combo share a nano USB receiver, no need to take up additional USB ports (Also the wireless keyboard and mouse can also be used separately). Plug and play, no software needed,convenient and efficient.
- 【Quiet & Type in Comfort】Wireless keyboard come with adjustable height tilt legs to increase comfort and prevent your wrists injury when typing for a long time.Our wireless keyboard adopts a silent structure. Soft membrane keys provide a quiet and comfortable typing experience.The wireless mouse is quiet without any clicking sound also.So whether at home or in the office, you can use this combo as you please without worrying about disturbing others.
- 【Full Size Keyboard】This keyboard saves desktop space while retaining its full size.The full size wireless keyboard with numeric keypad and 12 multimedia shortcut keys, such as play/ pause, volume increase and decrease, and search, to help you improve work efficiency.
- 【Auto Power Saving Function】Wireless keyboard and mouse have a smart auto-sleep mode to save power for long battery life. They will enter sleep mode after stop using a while(Refer to the instructions for details). Unplug the receiver or after the PC shutdown, they will enter sleep mode too.You can press any keys to wake. (battery life may vary based on user and computing conditions)
- 【Comfortable Optical Mouse】This silent wireless mice provides 3 adjustable DPI (800/1200/1600) to meet your different needs in terms of sensitivity.The compact lightweight design of wireless mouse and a hand-friendly contoured shape for all-day comfort, and smooth, precise tracking. Very suitable for office and daily use.
References to another workbook
External formulas depend on the source file, its path and permissions, and sometimes on the source workbook being open or refreshed. Choose Data > Workbook Links (or the available link-management command), verify the source path, and update or change it after saving a backup. Breaking a link converts dependent results to static values and removes future refresh behavior, so do it only when that loss is intentional. Unsupported linked structured references can produce #REF!; see Microsoft’s reference-error guidance.
Use Excel’s auditing tools
- Make a backup copy of the workbook.
- Open Formulas > Error Checking and inspect the first reported issue. Background checking can be configured in Windows under File > Options > Formulas and on Mac under Excel > Preferences > Error Checking; see Microsoft’s error-detection documentation.
- Use Show Formulas to compare a whole region.
- Use Trace Precedents to see inputs and Trace Dependents to see outputs.
- Use Evaluate Formula to step through nested logic.
- Test complex pieces in helper cells—for example,
=LEN(A2),=ISNUMBER(A2)or=TRIM(CLEAN(A2))—then rebuild the final formula incrementally.
When to switch from web or mobile Excel to desktop
Excel for the web calculates many formulas, but its auditing and workbook-management controls are not identical to Windows or Mac desktop Excel. Mobile apps are less suitable for tracing complex dependencies. If you cannot locate a circular reference, repair workbook links, inspect advanced dynamic-array behavior, or diagnose a feature-specific #CALC! error, save a copy and open it in desktop Excel. Do not assume a formula is unsupported on an entire platform without naming the exact function, edition and version; Microsoft lists applicability across Microsoft 365, Excel 2024, Excel 2021, Excel 2019, Excel 2016, web and mobile with feature differences.
Which Excel version do you need?
Buying software is rarely necessary to repair one formula. Free Excel for the web is suitable for basic calculations and sharing: Microsoft’s Excel page describes browser access with a Microsoft account and 5 GB of cloud storage. Desktop Excel is the better fit for extensive auditing, offline work, VBA, complex links or advanced workbook features. Microsoft 365 Personal and Family provide subscription-based desktop apps; Office 2024 is a one-time purchase for one computer without the same ongoing feature updates. Compare the editions at Microsoft’s Microsoft 365 versus Office 2024 guide. Google Sheets may suit browser-first collaboration, but Excel-specific functions, VBA, advanced auditing and exact workbook compatibility can suffer; see Google Workspace pricing for current plans.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Quick Recap
Two-minute final checklist
- Select the cell and inspect the Formula Bar.
- Confirm the formula starts with
=. - Turn off Formulas > Show Formulas if the whole sheet displays formulas.
- Change Text to General, then press F2 and Enter.
- Set calculation to Automatic.
- Press F9.
- Read the exact error code.
- Check quotes, separators, parentheses, sheet names and references.
- Test text-versus-number types, spaces, dates and lookup ranges.
- Trace precedents or open a copy in desktop Excel if platform limitations remain.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
