+ Reply to Thread
Results 1 to 5 of 5

Help combining two formulas

  1. #1
    Registered User
    Join Date
    08-02-2018
    Location
    Anchorage, AK
    MS-Off Ver
    2013
    Posts
    3

    Help combining two formulas

    I have two formulas that both work independently but I want to merge them together and every time I try I get the message that I have too many arguments, can someone help? I have included what I am trying to do and the two formulas.

    I have three date columns. The first date column contains the date an item is received. The second date column contains the date an action is completed and the third date column contains the date the action was supposed to be completed. I have a fourth column that tells you if the item was past due or not. The column that tells the user when the item was supposed to be completed uses a formula to calculate the due date. The past due column using a formula that currently looks at the item received date and the action completed date and populates with a 'Yes' or 'No' if the item was past due when it was completed. This is the formula:

    =IF(ISBLANK(J6),"",IF(ISBLANK(N6),"",IF(NETWORKDAYS(J6,N6,Holidays!$B$2:$B$12)>10,"Yes","No")))

    What I WANT the Past Due column to do is be a little predictive. I want it to tell you if the item was done late (which it currently does via the formula above) but I also want it to tell the user that the item is past due if there is no date entered in the action completed column AND today's date is greater than the date the action was supposed to be completed. The formula below will accomplish the second part of the task but I cannot figure out how to put the formulas together so that the Past Due column will tell a user the item was done late OR that it is late because it's past the due date and there is no date completed date entered.

    =IF(AND(ISBLANK(N8), TODAY() > O8), "Yes", "No")

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,302

    Re: Help combining two formulas

    See if this works the way you want

    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Registered User
    Join Date
    08-02-2018
    Location
    Anchorage, AK
    MS-Off Ver
    2013
    Posts
    3

    Re: Help combining two formulas

    Hmm it doesn't work. When I enter that formula, only 'Yes' appears in any of the Past Due cells, any cell that should be 'No' shows up as a blank cell.

  4. #4
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Help combining two formulas

    Try

    =IF(ISBLANK(J6),"",IF(ISBLANK(N6),IF(TODAY()>O6,"Yes",""),IF(NETWORKDAYS(J6,N6,Holidays!$B$2:$B$12)>10,"Yes","No")))

  5. #5
    Registered User
    Join Date
    08-02-2018
    Location
    Anchorage, AK
    MS-Off Ver
    2013
    Posts
    3

    Re: Help combining two formulas

    That one worked! Thanks for the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combining two IF formulas
    By CPAC in forum Excel General
    Replies: 10
    Last Post: 05-31-2016, 06:10 AM
  2. [SOLVED] Combining two formulas
    By johnmitch38 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-17-2015, 01:34 PM
  3. [SOLVED] Combining formulas
    By skip2mylew in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-04-2013, 10:43 PM
  4. Combining Two Formulas
    By Hornstinger in forum Excel General
    Replies: 3
    Last Post: 06-06-2012, 06:56 PM
  5. Help Combining Formulas
    By artiststevens in forum Excel General
    Replies: 2
    Last Post: 02-24-2012, 03:15 AM
  6. Combining two formulas
    By mrggutz in forum Excel General
    Replies: 13
    Last Post: 09-24-2010, 12:47 PM
  7. combining formulas and a IF then
    By faulkma in forum Excel General
    Replies: 3
    Last Post: 03-01-2009, 12:03 AM

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