Formula & functions intermittently fail to calculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Worksheet autocalc with min function in error 2
Avoiding redundant calculations 7
Conditional Formatting Formula 1
Excel Trying to create calculation function from Exponential 0
formulas display but don't calculate. 4
Formula does not calculate - Have tried F9 9
Vlookup Function Arguments are correct but nothing in cell 12

Back
Top