Negative Zero (-0.00)
 

Hiya,

Im just doing a spreadsheet and have two columns auto-sumed (A15 & B15 show
totals).

I have a forumla in C15 which is '=A15-B15', yet the answer is coming out as
-0.00 when in actual fact it should be 0.00 (without the negative in front).
Is there a way to fix this as it is messing up other forumla's in the
spreadsheet because it is a negative value and not a 'positive' zero.

Thanks,
Samuel.

Negative Zero (-0.00)
 

=ROUND(A15-B15,2)
--
David Biddulph

"Samuel" wrote in message
...
Hiya,

Im just doing a spreadsheet and have two columns auto-sumed (A15 & B15
show
totals).

I have a forumla in C15 which is '=A15-B15', yet the answer is coming out
as
-0.00 when in actual fact it should be 0.00 (without the negative in
front).
Is there a way to fix this as it is messing up other forumla's in the
spreadsheet because it is a negative value and not a 'positive' zero.

Thanks,
Samuel.

Negative Zero (-0.00)
 

Hi,

You'll probably find that the cell isn't zero at all but is showing as zero
because your only showing 2 decimal places.

Try this to eliminate it but be aware it does change the value of the number

=ROUND(A15-B15,2)

Mike

"Samuel" wrote:

Hiya,

Im just doing a spreadsheet and have two columns auto-sumed (A15 & B15 show
totals).

I have a forumla in C15 which is '=A15-B15', yet the answer is coming out as
-0.00 when in actual fact it should be 0.00 (without the negative in front).
Is there a way to fix this as it is messing up other forumla's in the
spreadsheet because it is a negative value and not a 'positive' zero.

Thanks,
Samuel.

Negative Zero (-0.00)
 

Hi,

Computers work in binary, we work in decimals

Here is everything you need to know about this issue (and more):

http://support.microsoft.com/kb/78113/en-us
http://support.microsoft.com/kb/42980
http://support.microsoft.com/kb/214118
http://www.cpearson.com/excel/rounding.htm
http://docs.sun.com/source/806-3568/ncg_goldberg.html

If this helps, please cliick the Yes button.
--
Thanks,
Shane Devenshire


"Samuel" wrote:

Hiya,

Im just doing a spreadsheet and have two columns auto-sumed (A15 & B15 show
totals).

I have a forumla in C15 which is '=A15-B15', yet the answer is coming out as
-0.00 when in actual fact it should be 0.00 (without the negative in front).
Is there a way to fix this as it is messing up other forumla's in the
spreadsheet because it is a negative value and not a 'positive' zero.

Thanks,
Samuel.