When we enter a formula, for example=A1+A2 and it happens that Excel does not calculate the result. Instead the formula just stays as it is, it might be possible that there is some strange option that has been chosen by accident. There are several ways to correct this.
Another way is:
If this happens while working on excel, then we need to press CTRL + ~ on our keyboard which will bring back the excel file to normal mode and then we can see the result.
So if the formulae do not calculate, we need to check all the above scenarios so that we can correct it and make the formulae work again.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.