A
alancunn
After 20 years of manually assigning payment formulas to dates in my
cash forecasting models (it only has to be done once a year), I am
tantalisingly close to doing it by function. In my test case, the 12
monthly paydates are in DC25C36 and the amounts are in DD25D36.
The days of the year are in DE25E389. The array formula
{=IF(DE25=(DC$25C$36),DD$25D$36,0)} works for any paydate in
January, but not beyond; I just get 0's. =VLOOKUP(DE25,$DC$25:$DD
$36,2,FALSE) works for the whole year, BUT gives me $N/A errors in all
non-paydates which screws up cross-summing. Thanks, Alan Cunningham
cash forecasting models (it only has to be done once a year), I am
tantalisingly close to doing it by function. In my test case, the 12
monthly paydates are in DC25C36 and the amounts are in DD25D36.
The days of the year are in DE25E389. The array formula
{=IF(DE25=(DC$25C$36),DD$25D$36,0)} works for any paydate in
January, but not beyond; I just get 0's. =VLOOKUP(DE25,$DC$25:$DD
$36,2,FALSE) works for the whole year, BUT gives me $N/A errors in all
non-paydates which screws up cross-summing. Thanks, Alan Cunningham