Results 1 to 10 of 10

Complex Formulas and If Formulas

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Question Complex Formulas and If Formulas

    Alright usually I am pretty good at Excel but this one has me stumped. In a row I have different dates, X's, and blanks. I have a new row that has the soonest date of all the columns including the "X". So I need the formula to give me the date that is happening the soonest. If the column has an "X" then it can be a date way off in the future so that it's not the soonest. If the column is a blank then I need it to be todays date, and if it's a date then what ever date it is. This is what I have that doesn't work and is huge. I know this is horribly complicated and could probably be done better but with that I am tracking it's what I have to use. Thank you in advance for the help.

    =MIN(H5,M5,Q5,S5,IF(ISBLANK(F5),(TODAY())),IF(ISBLANK(I5),(TODAY())),IF(ISBLANK(J5),(TODAY())),IF(ISBLANK(O5),(TODAY()))*IF("X",(1/1/2099)),IF("X",(1/1/2099)),IF("X",(1/1/2099)),IF("X",(1/1/2099)))

    Explained:

    F5 is a "X" or Blank
    H5 is a date
    I5 is a "X" or Blank
    J5 is a "X" or Blank
    M5 is a date
    O5 is a "X" or Blank
    Q5 is a date
    S5 is a date
    Last edited by Nuclearman83; 03-14-2012 at 02:14 PM. Reason: Bad Title

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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