Results 1 to 5 of 5

If Statement with multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2011
    Location
    Eastern, north carolina
    MS-Off Ver
    Excel 2007
    Posts
    6

    If Statement with multiple conditions

    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
    Last edited by Cdoyle; 01-31-2011 at 10:09 PM. Reason: Changintg Title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1