help with IF function (i think) please - thank you

[chrissywhittle]

I have a row/ columns of sales say from B to X, and rows 2 - 8. The
rows are separate sales of separate items and columns are the month
number (B to X) I would like to I think use an "IF" formula to do the
following: so that when the actual moneys come in say various months
later than that of the sale,


Coolum A B C D E
ROW
1 1000 100 50 75
2 2000 50 50 75
3 2000 100 100 100
Column R S T U V
ROW 10 1000
A1 sale wont come in until 18 months later, therefore the sale will
automatically appear in say row 10 column R or if the moneys come in 9
months after the sale it will appear in column I row 10. Basicly a
function that i can change the number of months the moneys take to come
in.
thank you

 

[robert111]

Record the month number of the data payment received, ie september = 9

Then in month 1 have a formula if(payment month number = this month
number, "paid", "") and copy across the 12 months.

So columns will remain empty until the "9 matches the 9"


month
1 2 3 4 5 6 7 8 9 10 11 12
sale1 paid

 

[chrissywhittle]

thank you very much