"Jon" wrote:
Is this a bug?
Most likely your misunderstanding, not a bug. But....
cell D80 =POWER((1 + D76/$D$82),$D$82)-1 and
is formatted as a percentage with 3 d.p.
Value = 12.683
.....It is difficult to offer assistance without knowing what is in D76 and
D82 -- the exactly values, not the what you might see displayed. If D76 and
D82 are formulas, not constants that you entered, then at a minimum, format
D76, D82 and D80 as Scientific with 14 dp, and post the values that you see.
cell D81 =(D79+(D78*D75))*D80
The answer comes up as 5073, whilst when working
out cell D81 manually:
35000 + (0.10 * 50000)) * .012683 = 5073.20
(I assume you mean 0.12683, which is 12.683%.)
First, 35000, 0.10 and 50000 might not be the exactly values in the cells,
merely the displayed values.
Second, the displayed value in D80, 12.683%, might really be any value
between 12.6825% and about 12.683499...%. In another posting, you say you
understand that. But....
In fact, with 12.6825% in D80, I get 5073.000000 using the other constants
as you specified them. So I suspect that is the real value in D80. Format
with 4 or more dp to see this.
PS: I confirm that with 12.683% and the other constants as you specified
them, I get 5073.20, as you did.
----- original message ----
"Jon" wrote in message
...
I've formatted a cell as a percentage column with a precision of 3 d.p.
However, when I work out the average, the answer is inaccurately.
So,
cell D80 =POWER((1 + D76/$D$82),$D$82)-1 and is formatted as a percentage
with 3 d.p.
Value = 12.683
cell D81 =(D79+(D78*D75))*D80
The answer comes up as 5073, whilst when working out cell D81 manually:
35000 + (0.10 * 50000)) * .012683 = 5073.20
Is this a bug?
MS Excel 2007
NOTE: It is noted when selecting the 'Excel' link within these discussion
groups, the user (me) is directed to a page where I have to select the
appropriate forum from a list of Microsoft products, rather than being
directed directly (excuse the pun) to the Excel discussion groups
(http://www.microsoft.com/office/comm...ang=e n&cr=US)
(http://www.microsoft.com/office/comm...verview.mspx#2)