Excel Made Easy

Formula does not calculate in Excel

Something is weird with my Excel sheet. When I enter a formula, for example
=AB2+AB3
Excel does not calculate the result. Instead the formula just stays as it
is. I am sure there is some strange option that has been chosen by accident,
but I can't come up with where.

Any help out there!

Answer:

you probably have the format of the cell as "text"

You can find similar Excel Questions and Answer hereunder

1) Formula converts date to quarter and year in Excel

2) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

3) How do I enter a formula in a cell using VBA (using Absolute Reference)?

4) how to write a formula in Excel

5) Conditional formatting with if statement in Excel

6) How to change the color of gridlines in a worksheet in Excel

7) How do i apply a formula to an entire column in Excel

8) Applying a countif formula only to visible cells in a filtered list in Excel

9) I have a cell with nested formulas that returns an error. In Excel, how can I step through the formulas to help with debugging?

10) How do I calculate monthly payment given Loan amount, Rate of Interest and period?