printing error when the answer is 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

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