How do I format a cell to not show 0 as being negative? Could it be the
formula I'm using? This is the formula in cell L321
=F321+G321-H321-I321-J321+K321
The numbers in those cells are formatted and entered to show only 2 places
after the decimal. Yet I sometimes end up with results like this
..00000000000022737367544 . HELP!

=ROUND(F321+G321-H321-I321-J321+K321,2)


"Jose" wrote:

How do I format a cell to not show 0 as being negative? Could it be the
formula I'm using? This is the formula in cell L321
=F321+G321-H321-I321-J321+K321
The numbers in those cells are formatted and entered to show only 2 places
after the decimal. Yet I sometimes end up with results like this
.00000000000022737367544 . HELP!

Do you know why this only happens with some of the cells and not all of them.
I have this formula copied into approximately 350 cells and about 70 of them
give me negative zero's (0.00), when the answer should just be 0.00 . Why
does this happen with only some and not all of the cells?

"Teethless mama" wrote:

=ROUND(F321+G321-H321-I321-J321+K321,2)


"Jose" wrote:

How do I format a cell to not show 0 as being negative? Could it be the
formula I'm using? This is the formula in cell L321
=F321+G321-H321-I321-J321+K321
The numbers in those cells are formatted and entered to show only 2 places
after the decimal. Yet I sometimes end up with results like this
.00000000000022737367544 . HELP!

It sounds like the eternal problem of being unable to give an exact
representation of most decimal numbers in fixed point binary.
You've seen the difficulty of giving an exact representation of 1/3 in fixed
point decimal, and you will find the same difficulty in representing 1/10 in
fixed point binary. Sometimes the roundings will even out, sometimes they
won't.
--
David Biddulph

"Jose" wrote in message
...
Do you know why this only happens with some of the cells and not all of
them.
I have this formula copied into approximately 350 cells and about 70 of
them
give me negative zero's (0.00), when the answer should just be 0.00 . Why
does this happen with only some and not all of the cells?

"Teethless mama" wrote:

=ROUND(F321+G321-H321-I321-J321+K321,2)


"Jose" wrote:

How do I format a cell to not show 0 as being negative? Could it be
the
formula I'm using? This is the formula in cell L321
=F321+G321-H321-I321-J321+K321
The numbers in those cells are formatted and entered to show only 2
places
after the decimal. Yet I sometimes end up with results like this
.00000000000022737367544 . HELP!