If Statement with multiple conditions

[Cdoyle]

I have a spreadsheet that basically has 3 columns “ Due Date” , “Date Paid” and “Paid”, depending on what is entered in the “Date Paid” column a statement will display in the “Paid” column. Need to mention that the due date will always be a fixed date such as 31 May 20XX. This is what I need it to do;

- If a date is entered in the ‘Date Paid” col, the “Paid” Col will display “Paid”. No matter what the date entered is, could be any date between now and 31 May 2011..

- If nothing is entered in the “Date Paid” col and it is before 30 days of the due date, the “Paid” col will display Due.

- If nothing is entered in the “Date Paid” col and it is within 30 days of the of the “Due Date” the “Paid” col will display “Warning”.

- If nothing is entered in the “Date Paid col and it is after the “Due Date”, the “Paid” col will display “Overdue”

This is the formula I have come up with,
=IF((TODAY()+30)<J2,"",IF(TODAY()>J2,"Overdue",IF( ISBLANK(I2),"Warning",K2*1)))

Everything works except if I enter a date in the “Date Paid” col nothing appears in the “Paid” col until it is within 30 days of the due date.

If this has to be a VBA, I am good with that, just not sure on how to write it, maybe a loop statement.

Any help is greatly appreciated

[scottylad2]

=IF((TODAY()+30)<J2,"",IF(TODAY()>J2,"Overdue",IF( ISBLANK(I2),"Warning",K2*1)))

[Cdoyle]

Thanks for the reply, first i should have explained my formula in a little better detail.
On my spreadsheet, Col J is the "Due Date" Col and Col I is the "Date Paid" Col. Col K as you see in the formula (K2*1) is just a col that I stuck the amount owed, in this case $194.00. That formula does work, but if you enter todays date in the "Date Paid" col, the "Paid" col will remains blank. If I change the "Due Date" to 15 Feb, in the "Paid col it will display the value of K2*1 or $194.00. If I leave the "Due Date" as 31 May the "Paid" col will remain blank. I would like for the "Paid' col to display "paid" whatever the date entered in the "Date Paid col.

[teylyn]

maybe like this

=IF(I2,"Paid",IF(TODAY()>J2,"overdue",IF(TODAY()+30<J2,"Due","Warning")))

[Cdoyle]

Thanks, that works perfectly. Awesome!!!!!!!

Charlie