printing error when the answer is 0

[Guest]

Hi there:
In my timesheet, I have set it up to not print 0's. I have a formula that,
when the answer is 0, and 0 it shows 0 on my screen, but prints as 1E-15. If
the answer is NOT 0, it is ok.
Any ideas?
Thanks!
John

 

[Frank Kabel]

Hi
maybe include a ROUND function. e.g.
=ROUND(your_formula,2)

 

[Jerry W. Lewis]

Excel (and most other general purpose numerical software) does math in
binary, not decimal. Most finite decimal fractions have no exact finite
binary representation, and so must be approximated. These binary
approximations can result in correctly calculated small non-zero answers
for ccalculations that would be exactly zero if done in decimal.

It is impossible to be certain whether this is actually what is going
on, since you have not given the calculation.

Jerry