Average stock price

[tjup73]

Dear all,

I'm struggeling with calculating how many extra stocks i should buy in order to achieve a certain average purchaseprice. Admitted i could just do some row to figure out but i turned into a bit of a quest to solve the problem and sofar i've been unable to create a beautful solution. Can you help me?

Hope you can help - thanks a lot

Thomas

 

[offthelip]

Assuming the 900 is in A2 the put this equation in A3

=A2*((B4-B2)/(B3-B4))

 

[tjup73]

Assuming the 900 is in A2 the put this equation in A3

=A2*((B4-B2)/(B3-B4))

Perfect - thanks a lot - it works like a charm