Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula & functions intermittently fail to calculate
I have notice recent instances where I have placed a formula or function in a
worksheet and the cell displays the equation and not the result. This occurs even though I have autocalculate enabled. Also pressing F9 does not resolve the issue. I have also tried toggling CTL+` without sucess Interstingly this does not occur in all cells in a worksheet, the function or equation shows results in other locations. -- LBarnes |
#2
|
|||
|
|||
Formula & functions intermittently fail to calculate
Check to make sure that the cell is not formatted as text. If it is then it
will only show the formula as you typed it. Be Lucky "LBarnes" wrote: I have notice recent instances where I have placed a formula or function in a worksheet and the cell displays the equation and not the result. This occurs even though I have autocalculate enabled. Also pressing F9 does not resolve the issue. I have also tried toggling CTL+` without sucess Interstingly this does not occur in all cells in a worksheet, the function or equation shows results in other locations. -- LBarnes |
#3
|
|||
|
|||
Formula & functions intermittently fail to calculate
That has happened a few times when I have been working with old workbooks, I
usually make sure the correct format is applied, then I do a replace and replace = with = (replace equal sign with equal sign), that usually triggers a calculation -- Regards, Peo Sjoblom "LBarnes" wrote in message ... I have notice recent instances where I have placed a formula or function in a worksheet and the cell displays the equation and not the result. This occurs even though I have autocalculate enabled. Also pressing F9 does not resolve the issue. I have also tried toggling CTL+` without sucess Interstingly this does not occur in all cells in a worksheet, the function or equation shows results in other locations. -- LBarnes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a formula to calculate the number of months to pay off a loan | Excel Discussion (Misc queries) | |||
Does anyone have a formula to calculate the car lease payments | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
how do I create a formula to calculate sales tax using Yes & No | Excel Worksheet Functions | |||
Formula displays does not calculate | Excel Discussion (Misc queries) |