ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   .01 or .02 diffrence in computation (https://www.excelbanter.com/excel-discussion-misc-queries/47932-01-02-diffrence-computation.html)

Dr.How via OfficeKB.com

.01 or .02 diffrence in computation
 
when try to subtract link cells they always show a .01 or .02 difference....

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

Dr.How via OfficeKB.com wrote:

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




All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com