IF FORMULA need help

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

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

[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"))
---
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" <[email protected]> wrote in message
news:[email protected]...
>
> 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!
>
>
> --
> Svea
> ------------------------------------------------------------------------
> Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
> View this thread: http://www.excelforum.com/showthread...hreadid=480746
>