Sales Realization Calculation

Hi!!!
I am looking for the formula for calculating Sales realization in installments i.e. if i am selling $100 in 1st year i am receiving 50% in 1st year and balance in next 3 years same thing happens in 2 year. Can anybody help me in this.

No macro i am looking for plain formula, if possible it is urgent
Thanks

I think we need a bit more info... ie how and where are you results to be displayed... how many sales do you have per year and where are those sales listed etc... will all sales follow the same pattern - ie recovered over 4 years - 50% year 1 and 12.5% for years 2-4 ?

So

Year2 = (Year1*16.66667%)+(Year2*50%)

etc...

If you can post a sample of your workbook and outline expected results you're more likely to get a prompt resolution.

I don't think you need row 4.

Try the following:

B6: =ROUND((B$5*0.5)+(SUMIF($A$3:A$3,">="&B$3-$B$2,$A$5:A$5)*(0.5/$B$2)),2)
copy across to H6

B7: =SUM($A$5:B$5)-SUM($A$9:B$9)
copy across to H7