Don't panic, one of these will definitely work
Excel Formula Not Calculating: Only the Formula Is Displayed | Formulas Not Calculating Automatically
Microsoft Excel is an incredibly powerful tool that can handle complex calculations with ease, but not when your Excel formulas aren’t working or aren’t calculating correctly. When this happens, it can be frustrating to track down the source of the problem and even more frustrating to find the right fix.
Fortunately, these problems often arise from simple errors or setup mistakes that can be easily fixed. If Excel formulas aren’t calculating or working for you, follow the steps below to fix the problem.
A common reason that Excel formulas don't work or calculate is that the calculation options in Excel may be set to manual instead of automatic. This means that the workbook doesn't automatically update when changes are made to the data or formulas.
