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