Take a look at the below image it shows cities and the average temperature in the city. In situations inside the formula, we require to pass the numerical values to get the desired result. #4 Don’t Enclose Numbers in Double Quotes One is we can turn on the calculation to automatic.Įither we can do one more thing we can also press the shortcut key F9, which is nothing but CALCULATE NOW under the Formulas bar.
But in order to enhance the speed of the large data files, the user might have changed the auto calculation to a manual one. But the result says 40 instead of 30.Īll the excel file calculations are set to Automatic. In cell D4, we have applied the SUM function to get the total value of cell D1, D2, and D3. In cell D1, D2, and D3, we have 10 as the value.
The below image shows one such situation. Sometimes in Excel, we see different numbers, but the formula shows different results. #3 Values are Different & Result is Different The solution is to try typing the same key again to get back the results of the formula rather than the formula itself. If you have typed this key accidentally, we may the result like the below picture.Īs I told reason could be the accidental pressing of the show formula shortcut key. In addition, there is a keyboard shortcut for it. To begin, select the formula tab, then formula auditing, and finally show formulas. One such moment is SHOW FORMULAS in excel SHOW FORMULAS In Excel In Excel, we can display formulas to investigate the procedure's relationship.
But if we don’t know which key we typed, we may end up getting an unusual result. Often in excel, when we are working in a hurry, we tend to type keys that are not required, and it is an accidental incident.
Now take a look at the first possibility of formula showing the formula itself, not the result of the formula. Now let’s look at the solutions for the reasons given above for the excel formula not working. Source: Excel Formula Not Working () #1 Cells Formatted as Text
You are free to use this image on your website, templates etc, Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked