problem combining 2 formulas
Hello, I have two rates of exhange and I want to find the mid point and
deduct 3% all in one formula.
The bank buy rate is 1.6706 (cell a1)
The bank sell rate is 1.6085 (cell a2)
so =sum(a1-a2)/2 gives me the difference beween the two rates and I divide
by 2 to find the basis for the mid point which is 0.03105 (cell a3)
Then I create another formula (a3 + a2)*0.97 to give me the mid point -3%
(or 97% of it the same either way)
How can I combine the two formulas? I always seem to have a problem with
circular refererences.
thanks
kinsey
--
kinsey
|