Re: Date Formulas

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Something about formula formatted incorrectly do you want to correct incorrect formula do you wish to correct) I ran into it so long ago that I just started using =Sum() instead to not get the warning. evidently the formatting for dealing with cells has to be different than strictly with numbers. I don't know just know what it does for me.

JE McGimpsey wrote:
In article <eOIytarXIHA.5472@xxxxxxxxxxxxxxxxxxxx>,
Phillip Jones <pjones1@xxxxxxxxxxxx> wrote:

But if your doing something to cells, say cell A1 plus 1 or even A1 plus A2; then Excel 2004 will throw a warning that the formula is incorrect and ask whether you want to correct it. using =Sum(A1+1) or =Sum(A1+A2) doesn't bring up the warning.

XL04 certainly *shouldn't* bring up a warning that the formula's incorrect...

...or if it does, it should bring up the *same* warning for SUM().

What warning is displayed?

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |pjones@xxxxxxxxxxxx, ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto:pjones@xxxxxxxxxxxx

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>
.

Relevant Pages

  • Re: Typecasting in C
    ... > maybe a warning is needed, ... It's incorrect in C, regardless of the particular implementation; ... passing a pointer argument for a "%p" format calls for a cast to void* ... A warning about incorrect code is not clutter. ...
    (comp.lang.c)
  • Re: Problem with malloc
    ... >> value, the warning is suppressed. ... >> code is still incorrect and will break on some systems. ... malloc in order to cast its return value to something, ... It should definitely an unsigned int. ...
    (comp.lang.c)
  • Re: what does this warning mean ?
    ... This warning is bogus and incorrect. ... int mainis indeed an old-style function ...
    (comp.lang.c)
  • Re: Look what the crappy update does to the compiler
    ... Dunno if it's related, but did you also mention the incorrect ... the new Delphi compiler complains about a return value being ... is behind the incorrect warning, it can only be sign of a bad ...
    (borland.public.delphi.language.basm)