Setting up 30, 60, and 90 days delinquency

[pj]

I have entered my codes as the following:

=IF(L36<=30,K36+0," ")
=IF(L36<=60,IF(L36>=31,K36+0,IF(L36<=30," ")),IF(L36<=31,K36+0,IF(L36>=61,"
")))
=IF(L36<=90,IF(L36>=61,K36+0,IF(L36<=60," ")),IF(L36<=60," ",IF(L36>=91," ")))
=IF(L42>=91,K42+0," ")

I want the cell to read as "zero" until they make a payment, this way all my
columns with have a total amount due. However it reads as "value" and
doesn't allow me to total the columns. If no payment or balance I would like
the cell to read "zero" or "0.00".

Please help,
Pj

 

[Trevor Shuttleworth]

PJ

you don't say which cells these formulae go in and where the data is entered
so it's a bit difficult to see the sequence of events

Regards

Trevor

 

[Dave Unger]

pj,

See if these simpler formulas will work for you


=IF(L36<=30,K36+0,0)
=(L36>30)*(L36<61)*K36+0
=(L36>60)*(L36<91)*K36+0

Dave

 

[Dave Unger]

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)

=(L36>30)*(L36<61)*(K36+0)

=(L36>60)*(L36<91)*(K36+0)

Dave

 

[Dave Unger]

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)

=(L36>30)*(L36<61)*(K36+0)

=(L36>60)*(L36<91)*(K36+0)


Dave

 

[Dave Unger]

pj,

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)
=(L36>30)*(L36<61)*(K36+0)
=(L36>60)*(L36<91)*(K36+0)

Dave

 

[Dave Unger]

pj,

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)
=(L36>30)*(L36<61)*(K36+0)
=(L36>60)*(L36<91)*(K36+0)

Dave

 

[Dave Unger]

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)
=(L36>30)*(L36<61)*(K36+0)
=(L36>60)*(L36<91)*(K36+0)
Dave

 

[Dave Unger]

pj,

Apologies for the double post, my previous message got truncated
somehow.

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)

=(L36>30)*(L36<61)*(K36+0)

=(L36>60)*(L36<91)*(K36+0)

Dave