Excel - won't automatically calculate

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

I am having trouble with one particular cell in my worksheet that won'
calculate. I can copy a formula into the cell and it will work but i
I type a formula (even the same formula I copied) it will not work. I
will also not work if I modify the formula I copy into the cell. Whe
I say "not work" I mean that excel displays the formula instead of th
answer to the formula.

The formula (in cell B65) I want to work is:
=IF(ISBLANK(AD54),"Cash Balance Due","")

Note: the Automatic radio button is selected (under Tools -> Options -
Calculation)
 
Hi
your cell is probably formated as 'Text'. select your cell and goto
'Format - Cells'. choose 'General' and retry inserting your formula
 
Back
Top