.01 or .02 diffrence in computation

  • Thread starter Dr.How via OfficeKB.com
  • Start date
D

Dr.How via OfficeKB.com

when try to subtract link cells they always show a .01 or .02 difference....
 
J

Jerry W. Lewis

Likely the cells contain more decimal places than they are formatted to
show. You can use the ROUND function or
Tools|Options|Calculation|Precision as displayed

If this does not solve your problem, then you need to provide more
information.

Jerry
 
Top