Setting up 30, 60, and 90 days delinquency
pj,
I did post this once, didn't seem to go anywhere, apologise if it shows
up twice.
Place brackets around the K36+0 on the last 2 formulas, won't work
correctly if a value other than 0. Missed that before, sorry about
that.
=IF(L36<=30,K36+0,0)
=(L3630)*(L36<61)*(K36+0)
=(L3660)*(L36<91)*(K36+0)
Dave
|