hi,

i have a small problem....here's what it looks like:

A(flag) B(date of sale) C(sale amt) D(Feb06) E(Mar06) F(Apr06).....
1 0 25000

ok heres where the problem is.....when there is a sale, the flag in col A
changes from 0 to 1. then the month of sale is entered in col B..... now the
first installment of the payment has to start in the month of the sale....for
eg. if the first sale is for 25000$ in the month of Mar06, then 50% of $25000
shud appear in Mar06 column and 25% of $25000 in the col 5 months from
Mar06(i.e. in Aug06) and the last 25% in the col 10 months from Mar06.

kindly help me if my problem is clear!