Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dr.How via OfficeKB.com
 
Posts: n/a
Default .01 or .02 diffrence in computation

when try to subtract link cells they always show a .01 or .02 difference....
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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....


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MOD function computation error Marian Megami V Excel Worksheet Functions 7 August 24th 05 09:48 PM
Finding negative and positive diffrence Ashish Doshi Excel Worksheet Functions 2 May 24th 05 11:54 PM
Highlight Active Cell...With a Diffrence Peter Excel Discussion (Misc queries) 1 January 31st 05 01:18 PM
computation problems -- formulas JRH New Users to Excel 5 January 21st 05 05:36 AM


All times are GMT +1. The time now is 10:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"