Please, I am trying really hard to work this out, but still I couldn't
come to result I want.

This is the example (invoices - paid, not paid...)

column A..................... column B...................... column C
DUE DATE....................PAID ON........................COMMENT
10.11.05.....................07.11.05............. ...........paid, on
time
15.11.05.....................20.11.05............. ...........paid,
late
20.11.05...................(empty cell)......................not paid,
late
04.12.05...................(empty cell)......................not paid,
not late

So, you see, I can have 4 situations. In column C I tried to write out
these 4 comments, depending of date writen in column B, with help of IF
formula. I succed to get something, but when I tried to make few IFs one
after another I always got mistake in formula.

I understand that I have to compare if cells in column B are empty or
not. If they are not empty, customer surely paid - maybe on time, maybe
not - depending if date in column B is after or before date in column A.
Still, if the cell in column B is empty than surely didn't pay, still
the question is - is the invoice in due date or not.

I think that for expert this is something very simple. So I kindly ask
you to help me with correct formula.

Thank you so much!


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