Why do I see the formula in the cell??

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

Ed from AZ

I have an IF formula in a merged cell (XL 2003):
=IF(SUM(AO6:AO13))=AB13,"","Error!! Daily Miles Totals Do Not Equal
Daily Route Totals!!"
The merged cell is formatted as Text, Word Wrap on.

This is the only formula that is visible in a cell. Tools >> Options
At first, I started writing the formula with only "Error!" for the
False response, and it was okay. Then I added more words, and
suddenly the formula appears. Now I try to delete words, and it won't
go away. I have deleted the formula and re-written it the same, and
it's not visible - until I enter just one more character . . .

What's going on? Is there some Excel limit I'm going over?

Ed
 
The problem is having the cell formatted as Text
Format the cell General; open it with F2 and press Enter to recomputed it
best wishes
 
D'oh!!! Thank you.

Ed


The problem is having the cell formatted as Text
Format the cell General; open it with F2 and press Enter to recomputed it
best wishes
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email









- Show quoted text -
Click to expand...
 
Back
Top