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

Place brackets around the K36+0 in the last 2 formulas, won't work
correctly if a value other than 0. Missed that on my 1st reply, sorry
about that.
=IF(L36<=30,K36+0,0)
=(L3630)*(L36<61)*(K36+0)
=(L3660)*(L36<91)*(K36+0)
Dave

Reply With QuoteReply With Quote