Help with Formatting cells

J

Jose

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!
 
J

Jose

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?
 
D

David Biddulph

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