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