Setting up 30, 60, and 90 days delinquency
 

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

Setting up 30, 60, and 90 days delinquency
 

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


"pj" wrote in message
...
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

Setting up 30, 60, and 90 days delinquency
 

pj,

See if these simpler formulas will work for you


=IF(L36<=30,K36+0,0)
=(L3630)*(L36<61)*K36+0
=(L3660)*(L36<91)*K36+0

Dave

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

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

Setting up 30, 60, and 90 days delinquency
 

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

Dave

Setting up 30, 60, and 90 days delinquency
 

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

Dave

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

Setting up 30, 60, and 90 days delinquency
 

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)

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

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

Dave