Thread: Setting up 30, 60, and 90 days delinquency
View Single Post
  #4   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,


Add brackets to K36+0 in last 2 formulas, else won't work if anything
other than a 0. Sorry, missed that before.

=IF(L36<=30,K36+0,0)

=(L3630)*(L36<61)*(K36+0)

=(L3660)*(L36<91)*(K36+0)

Dave

Reply With QuoteReply With Quote