Negative Zero (-0.00)


S

Samuel

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.
 
Ad

Advertisements

M

Mike H

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top