+ Reply to Thread
Results 1 to 3 of 3

Adding one more condition to my IFS function

  1. #1
    Registered User
    Join Date
    11-30-2021
    Location
    Phoenix, Arizona
    MS-Off Ver
    Microsoft 365 MSO (Version 2110 Build 16.0.14527.20270) 64-bit
    Posts
    5

    Lightbulb Adding one more condition to my IFS function

    Right now this formula works perfectly:

    =IFERROR(IFS(AND(OR(I2="X",J2="X",K2="X",L2="X"),M2>=$A$2),"Completed",H2="","Unclaimed"),"In Progress")

    I'd like to add one more condition.

    Column M is the date we completed a task. Sometimes a team member will forget to add the date completed into column M. If there is an X in columns I, J, K, OR L, and Column H is NOT blank, but column M is blank, I'd like to return the value "<-- Missing date"

    In the attachment, cell N4 should return the value "<-- missing date"

    I tried this formula, and it works! Except this one doesn't return the value "Completed" when there's an X in columns I, J, K, OR L.

    =IFERROR(IFS(H2="","Unclaimed",AND(OR(I2="X",J2="X",K2="X",L2="X"),M2=""),"<-- Missing date",AND(OR(I2="X",J2="X",K2="X",L2="X")*H2="*",M2>=$A$2),"Completed"),"In progress")
    Attached Files Attached Files
    Last edited by analyst_; 12-28-2021 at 04:53 PM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Adding one more condition to my IFS function

    Please try

    =IFS(H2="","Unclaimed",COUNTIF(I2:L2,"x"),IF(M2,"Completed","<-- Missing date"),1,"In Progress")
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-30-2021
    Location
    Phoenix, Arizona
    MS-Off Ver
    Microsoft 365 MSO (Version 2110 Build 16.0.14527.20270) 64-bit
    Posts
    5

    Re: Adding one more condition to my IFS function

    Works great! And much more simplified than what I was trying to do!

+ 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] Adding a third condition
    By meatychi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-14-2022, 06:04 AM
  2. [SOLVED] Adding condition to FILTER function
    By mikehk in forum Excel General
    Replies: 3
    Last Post: 03-06-2021, 10:10 AM
  3. [SOLVED] value adding with condition.
    By nnish in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-28-2016, 02:22 PM
  4. Adding another condition to my sum if function
    By superboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2014, 01:30 PM
  5. Adding 1 more condition to an IF function
    By seraphim666 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2013, 08:21 AM
  6. condition adding
    By choy96 in forum Excel General
    Replies: 8
    Last Post: 03-24-2010, 07:22 AM
  7. adding part of a function on condition.
    By foxgguy2005 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-26-2005, 09:45 AM

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