# What to Do If Formula Is Not Working in Excel

Hello! Check the links in the molecular formula. Perhaps there are references to hidden lines in the formula. Use SUM(J9:J10) However, we have to be a little careful when using the “Show Formulas” option, otherwise you may get something like the one below. Excel formulas not working? Discover five errors that can prevent Excel formulas from being calculated and learn how to fix them. I checked the cell formats, the content of the formulas, etc. and everything is the same for line 100 as for the lines above. I need to miss something in the way I approach the lines of my formula? All Excel functions have one or more required arguments. Some functions also have optional arguments that are placed in [square brackets] in the formula syntax. Method 2: Use Find and Replace (Ctrl + F). Select to replace = with = and this will cause Excel to update the formulas and start calculating as usual. Using absolute referencing, you can correct your range of formulas so that you can copy it from one cell to another. This section summarizes the most common errors that occur when creating formulas in Excel and solutions to fix them. I have the same problem as Abby – I can`t run a simple AutoSum formula – it just shows a zero.

I tried both ways (=B21+B40) and =(SUM(B1, B40). And when I click on the previous AutoSum formulas that worked perfectly, they are reset to zero. According to Excel calculation rules, your formulas should not reference result cells as a range. If you do, you will see circular reference errors. In your case, you should use the following formula: I have a few Excel spreadsheets that I have been using for a few years, suddenly the formulas in none of the tables are updated. There is #Value for all my formulas in all spreadsheets. What may have changed – do you think Excel needs to be reinstalled? Since you get a correct result with the formula, it may not be worth imitating as a macro. The “Show formulas in cells” option could have been triggered. There are two ways to solve this problem.

In this case, the formula calculates (since it returns a value), but the result is incorrect (instead of the score of exam 2, it gives the score of exam 1). For example, in our table above, we used absolute cell referencing to make it easier to copy formulas. First of all, you may have forgotten the equal sign. All formulas in Excel must start with an equal sign (=). If you omit this, Excel simply treats the formula as text: the problem with the extra spaces can be solved with the help of the Trim formula. In general, the cutting formula finds more than one space between the words and is removed. But technically, this will be a mistake because our formula cell references are in a loop. The reasonable problem of having “the sum of the car adds nothing and only gives zero accordingly” here worked in previous versions.