Why do I see the formula in the cell??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed from AZ - 03 Apr 2008 14:49 GMT

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

>> View tab, Formulas is NOT checked.

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

Reply to this Message

Bernard Liengme - 03 Apr 2008 15:04 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

>I have an IF formula in a merged cell (XL 2003):
> =IF(SUM(AO6:AO13))=AB13,"","Error!! Daily Miles Totals Do Not Equal
[quoted text clipped - 13 lines]
>
> Ed

Reply to this Message

Ed from AZ - 03 Apr 2008 16:49 GMT

D'oh!!! Thank you.

Ed

On Apr 3, 7:04 am, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca>
wrote:

> The problem is having the cell formatted as Text
> Format the cell General; open it with F2 and press Enter to recomputed it
[quoted text clipped - 23 lines]
>
> - Show quoted text -

Reply to this Message

Rate this thread: