differing results

[Guest]

assume:
a1: 5
b1: =sum(c1,d1)
c1:$73.33
d1:$116.14
e1: =b1/a1 [would = $37.89]
f1: =e1*a1 [should = $189.45]
however, f1 is always coming up $189.47
what would it take to get f1 to show an amount equal to: a1*the $ result of
e1?
standard formula doesn't seen to be working

 

[Peo Sjoblom]

http://www.mcgimpsey.com/excel/pennyoff.html

 

[alordofchaos]

$189.47 is actually the correct answer, because e1 ($37.89) is really
37.894. Do this with a calculator and see.

Although Excel hid the .004 from you when you formatted it to show the
dollar sign, it kept it, and multiplied it by a1 (5), hence the 2 cents
difference.

To "fix" this, you could have to apply ROUND to steps e1 and f1
(anywhere that you multiply or divide).

 

[Trevor Shuttleworth]

Cliff

just to add to the other answers, the answer *is* $189.47

f1 = e1*a1, and e1 = b1/a1, therefore
f1 = (b1/a1)*a1, hence
f1 = b1, and b1 = sum(c1,d1), so
f1 = sum(c1,d1)
f1 = $73.33 + $116.14
f1 = $189.47

which seems a long way round to get the number you first thought of ...

Whatever; you've got an expensive spreadsheet ... make it work for its money

Regards

Trevor