software

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 quot;IFquot; formula to do the
following: so that when the actual moneys come in say various months
later than that of the sale,CoolumA BCDE
ROW
110001005075
22000505075
32000100100100
ColumnRSTUV
ROW 101000
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--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: www.excelforum.com/member.php...oamp;userid=32158
View this thread: www.excelforum.com/showthread...hreadid=520047
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, quot;paidquot;, quot;quot;) and copy across the 12 months.

So columns will remain empty until the quot;9 matches the 9quot;month
1 2 3 4 5 6 7 8 9 10 11 12
sale1 paid--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=520047
thank you very much --
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: www.excelforum.com/member.php...oamp;userid=32158
View this thread: www.excelforum.com/showthread...hreadid=520047