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?
ROUNDING ERRORS