Formula does not Calculate in Microsoft Excel

 

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 itis it might be possible that there is some strange option that has been chosen by accident. There are several ways to correct this.

      1. Its possible that the cell formatis probably set to Text so we need to set it as general.

    • For this you can click Ctrl + 1 on the keyboard.
    • Click on General
    • Click on Okay

img1

 

Another way is:

    • Select a cell and right click with the mouse.

img2

 

    • Click on Format Cells.
    • You will get a pop up which is the format cells dialog box.
    • Click on General and click on Ok.

img3

 

      2. We can also check options. It is possible that Auto Calcis switched off.
      For this you need to follow below mentioned instructions.

    • In the Excel Ribbon, Click on the Formulas tab.

img4

 

    • Click on Calculation Options
    • Click on Automatic

img5

 

    3. There can be another issue also wherein a key is pressed by which a formula is displayed instead of the result. If CTRL + ~ is pressed then it would show the formula instead of the result.

img6

 

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.

img7

 

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.



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>