For =(35000 + (0.1 * 50000)) * 0.012683
I get 507.32 with Excel as well as my calculator..
Regarding
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
This is the behavior I get in FIREFOX.. Internet Explorer works fine.
I use IE Tab addon for Firefox
https://addons.mozilla.org/en-US/firefox/addon/1419
It renders the page with IE engine within Firefox...
--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.
"Jon" wrote:
I'm aware of that, but still I'm not sure why the answer was 'rounded up';
maybe my calculator is incorrect? :)
"Sheeloo" wrote:
Formatting a cell to 3 decimals does not change the underlying value...You
can see the underlying value in the FORMULA bar or by increasing the decimal
places in the format.
So even when you see 12.683 the actual value might be something like
12.68350023457
The underlying value is used in calculations and not the displayed value
hence the difference...
--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.
"Jon" wrote:
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)