IF FORMULA need help

S

Svea

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!
 
S

Svea

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

=IF(B2="";"not paid, ";IF(B2>A2;"paid, late";"paid on
time"))&IF(B2="";IF(A2>TODAY();"late";"not late");"")

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

Anyway, I would appreciate shorter version!
 
D

David McRitchie

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"))
 
Top