If Excel Formulas are not working properly or are not calculating, execute the solutions mentioned below: Make sure that you have entered the formula, not the text Start MS Excel in Safe Mode Disable ...
If Excel is not recognizing functions after reboot, change calculation settings, disable Show Formula, run Excel Troubleshooter, etc.
Build bulletproof workbooks with named ranges, dynamic tables, and Excel's built-in error-checking tools.