differing results
 

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


--
Cliff

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

--

Regards,

Peo Sjoblom

"garpavco" wrote in message
...
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


--
Cliff

$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).

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


"garpavco" wrote in message
...
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


--
Cliff