"Precision as displayed" means that a cell showing $1.51 will equal exactly
$1.51, not $1.51211231232. The "accuracy" you lose by using this option is
probably irrelevant for accounting, but not for calculations which require
more precisions; i.e., engineering or scientific measurements.

Dave
--
Brevity is the soul of wit.


"WLMPilot" wrote:

JLatham, I was reading your response and tried your suggestion on a blank
workbook. I got a message saying "Data will permanently lose accuracy".
What is this about?

Les

"JLatham" wrote:

No experience with Amazon accounting at all, so this is in the way of a
guess. But I have had to deal with Excel being used to perform calculations
and having to deal with similar minor differences in calculation between its
results and those from an accounting program. We found that using Precision
as Displayed cured the problem. That is set using Tools | Options | and a
check on the [Calculation] tab.

"Richard Wrigley" wrote:

Gretings from Norfolk (UK)

I have just found this group, so may be asking a question previously
answered.

I am trying to set up n excel spread sheet for a friend for her sale of
books on Amazon.

Does anybody know the way Amazon calculate their fees and VAT - I know the
percentages and deducted amounts, but every time I try I get errors between
their figures and my calculated values of + or - 1 penny.
I have tried various rounding techniques, but to no avail

Any help would be appreciated.
--
Richard.

"I have yet to see any problem, however complicated, which when looked at in
the right way, did not become still more complicated"
Poul Anderson