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