how about

=(D3*(1+B3))*(1+B4)
and for the next period
=((D3*(1+B3))*(1+B4))*(1+B5)

note the extra brackets


but you do need to change the ratio's into decimals
b3 = 0.2
b4 =1
b5=0.5


--
Greetings from New Zealand

"TUNGANA KURMA RAJU" wrote in
message ...
I have range A2:B7 bonus shares history of a company.I am looking for a
function in E3 to get Number of shares I hold On Sale date(E2).My data is
Col A -------------Col B ---------Col C ------Col D ----------Col E
1. Date -------------BonusRatio--- ------ ------Buy Date ----- Sale
Date
2. 07-Jul-2004 ------ 1:1 ---- ------- -----10-Feb-2005 ---
25-Aug-2006
3. 03-Mar-2005 ----- 1:5 ---- -------- ---- 100 ---
?
4. 19-Jan-2006 ----- 1:1
5. 25-jan-2007 ------ 1:2
6.
7.

D2=shares buy date,D3= number of shares bought.I am looking for a function
in E3,how many shares I hold on sale date i.e on 25-aug-2006(sharesI
bought+bonus shares yield).answer is 240.