rounding problems

[rockell333]

i know that excel is known to be more accurate than
lotus.. but here is a problem..
when dividing numbers where the sum has a decimal with
many digits to the right.. well for my reports we only
show one decimal.. so when trying to figure out the
variance between the two cells it ends up rounding to a
number that looks very wrong... ie: on the screen and in
print you see 6.2 and 6.3 so when dividing.. instead of
reading (.1) it might read .3 or something.. because the
true values of 6.2 and 6.3 are lets say 6.27993998 blah
blah blah.. is there a way to to keep the digits to the
right as one and have the variance look correct.. (even
if the truth of the variance is probably closer to what
excels figures)

 

[JE McGimpsey]

Don't know that I've seen anything about XL being more accurate, but you
can use the ROUND() function to make your values and display the same.
However, it's not a panacea, as cumulative rounding errors can still
cause inaccurate sums.

See

http://www.mcgimpsey.com/excel/pennyoff.html

and

http://cpearson.com/excel/rounding.htm

 

[Ragdyer]

Try this page of John's for some insight:

http://www.mcgimpsey.com/excel/pennyoff.html

 

[Tom Ogilvy]

=round(A1,1)-round(A2,1)

 

[Guest]

thanks all

=round(A1,1)-round(A2,1)