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)