View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
flavio.c flavio.c is offline
external usenet poster
 
Posts: 1
Default calculation accuracy

Hi friends,

I have a simple question about calculation accuracy (excel 2002) that drives
me crazy: just enter in
A1 value 388
B1 value 372.58
C1 value 15.42

and then in a new cell the formula = A1 - B1 - C1

One would expect 0 as result, instead gets 1.59872E-14

Do you know why this occur? There is a way to force the result to 0 anyway?

Thanks a lot for any help or suggestion on this.

Ciao

Flavio