Excel formulae start doing strange things

have you try to use the formula evaluation tools to trace the problem. It is
a very useful tools.

Bobocat

"WarrenC" <WarrenC.29k4bz_1150565402.1184@excelforum-nospam.com> ¼¶¼g©ó¶l¥ó·s»D:WarrenC.29k4bz_1150565402.1184@excelforum-nospam.com...
>
> The co-workers spreadsheet were simple addition/subtraction formula. The
> ones I've had problems were in this format:
>
> =IF(a1-b1-c1-d1<>0,"oops",0). Even though the correct answer is zero, I
> would get "oops" as the result. If I opened a new spreadsheet and and
> entered the same thing, it would work. Also have had the problem were
> the formula would work, but as soon as I copy it, it wouldn't. However,
> if I deleted this copied version and then typed it in, it would work. I
> only come across this type of issue occasionally, but it gets to be a
> bother.
>
>
> --
> WarrenC
> ------------------------------------------------------------------------
> WarrenC's Profile:
> http://www.excelforum.com/member.php...o&userid=35524
> View this thread: http://www.excelforum.com/showthread...hreadid=552933
>

thanks

Warren