You solution works, it's just as good as anything else, you have
to do several comparisons. Your concatenation is perhaps
unique but it shows an understanding of how solutions are built
up on other solutions (like programming).

=IF(B2="", IF(A2<TODAY(),"past due","billed, not paid"),
IF(A2<B2, "paid late", "paid on time"))
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Svea" wrote in message
...

Look! I succeed to do it... but I think this formula looks to
complicated! Don't you think?

=IF(B2="";"not paid, ";IF(B2A2;"paid, late";"paid on
time"))&IF(B2="";IF(A2TODAY();"late";"not late");"")

For me... it works and I am happy that I did it!

Anyway, I would appreciate shorter version!


--
Svea
------------------------------------------------------------------------
Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
View this thread: http://www.excelforum.com/showthread...hreadid=480746