If your function wont calculate in Excel, this is usually due to either the formatting of your cells or the Excel Calculation option setting.
Click on the link that describes your current problem, for an explanation and solution to the problem:
|Case 1: The Cell Displays the Function Instead of its Calculated Value|
|Case 2: The Formula Doesn't Update|
|1||TEXT1||=LEFT( A1, 1 )|
|2||TEXT2||=LEFT( A2, 1 )|
You type in a function and when you press Enter, the cell displays the function as you typed it, instead of calculating the function's value.
This problem generally arises because the cells containing your formula are formatted as 'text' instead of the 'General' type.
This frequently occurs when you insert a new column, next to a column that is formatted as text. In this case, the new column 'inherits' the formatting of the adjacent column.
To correct this, you need to change the formatting of the cell and then force the cell to recalculate:
You have a function that you know is correct, but when you change the values of its dependent cells the function continues to show the old value.
This problem is usually caused by the setting of the Calculation option for your Excel spreadsheet.
By default, Excel will recalculate its functions every time a cell value changes. However, the Calculation option can be set to switch off automatic recalculation, and once switched off, it is very easy for the user to forget about this option.
To correct this you need to set the Calculation option to Automatic. To do this:
This sets your Excel spreadsheet back to the Automatic setting so that it recalculates formulas every time a change is made to the spreadsheet.