ROUNDING ERRORS 
Author Message
 ROUNDING ERRORS

No way. It is set to *SHOW* 2 decimal places, actual content may well be
$10.554 kind of thing. Calculating correct, showing wrong in other words.
"Precision as displayed" may satisfy you if the actual payments are rounded
as your sheet displayes.

A computer IS a little off, but that's around14th - 15th digit and should
not be of annoyance in business sheets. (Post this again when you start
computing rocket navigation ;-)

HTH. Best wishes Harald


Quote:
> MY PAYROLL SPREADSHEETS, WITH CALCULATIONS BOTH BY ROWS
> AND BY COLUMNS, DOESN'T ROUND CORRECTLY.  IT'S SET TO
> ROUND TO 2 DECIMAL PLACES, BUT EACH QUARTER IS ALWAYS OFF
> A FEW CENTS???!

> VERY FRUSTRATING.  ANY HELP?



Thu, 08 Jul 2004 06:32:32 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Excel Rounding Error?

2. Rounding error in Excel VBA

3. rounding error??

4. Rounding errors

5. Format$ rounding error.

6. rounding error

7. Rounding Errors on a form

8. Rounding error?

9. Rounding Error

10. rounding error in calculate age routine


 
Powered by phpBB® Forum Software © phpBB Group