I have a range A2:B7 bonus shares fhistory of a company. I need a function
that calculates automatically how many shares I hold when I put input date in
D2
Col A ........Col B ........Col C........Col D
1. DATE ........BonusRatio..Buydate ......SaleDate
2.07-Jul-04 .....1:1 ...........10-Feb-05.....25-Aug-06
3.03-Mar-05.....1:5 ............. 100 ........... ?
4.19-Jan-06 .....1:1
5 25-Jan-07 ....1:2
6.
7.

C3= number shares bought on 10-Feb-05
C2= Buy date
I want a formula in D3 that calculates how many shares I hold on sale date(D2)
.The formula should calculates number of shares I hold on sale date whenever
I change (input) saledate or buy date or number of shares.
From the above saledate I must get the answer through formula 240.If I
change sale date to 01-Feb-2007 I must get the answer 360.If I change Buydate
to 15-May-2004 I must get the answer 720.The formula should take care of
whole range of Bonus history table(A2:B7),at present A6,A7 are blank.
I am very grateful If any body gives me a compact formula to achieve this.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1