View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Unger Dave Unger is offline
external usenet poster
 
Posts: 153
Default 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