Results 1 to 8 of 8

Multiple IF criteria, return alternative value from multiple IF criteria

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2020
    Location
    Libreville
    MS-Off Ver
    Office 10
    Posts
    42

    Angry Multiple IF criteria, return alternative value from multiple IF criteria

    Hi,
    I am stuck with a formula that looks simple but that is not working. Actually, I have 8 columns as follows: A2 for action items, B2 for start date, then a rage of C2, D2, E2 and F2 for the four weeks of the month; and then G2 for action closure date, and finally H2 for action status. Now, I want is this:
    1) IF A2 is blank, then H2 should show "blank"
    2) IF A2 contains text (action items), then H2 should show "Open"
    3) IF B2 contains date (action resolution start date), then H2 should show "Ongoing"
    4) IF range (C2:F2) contains "Ok", OR G2 contains date (resolution completion date), then H2 should show "closed"

    The formula I tried is: =IF(A2="","",IF(ISNUMBER(B2),"Ongoing",IF(OR(COUNTIFS(C2:F2,"ok"),ISNUMBER(G2)),"Closed","Open")))
    But it works only on the first 3 criteria, but would not work on the last. So, I can get Blank, Open, and Ongoing, but I can't get Closed.

    Please help!
    Attached Files Attached Files
    Last edited by Joe.Mintsa; 09-15-2022 at 12:37 PM. Reason: Attach a ample excel sheet

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lookup multiple criteria in multiple columns in multiple rows; return true if exists
    By ufdlim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2019, 02:03 PM
  2. Alternative to IF with multiple criteria.
    By garfolino in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-28-2015, 08:07 PM
  3. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  4. [SOLVED] Sumifs or alternative formula needed for multiple criteria
    By bwmuhich in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-31-2015, 02:41 PM
  5. [SOLVED] Alternative to COUNTIFS with multiple criteria
    By Ricardo Mass in forum Excel General
    Replies: 2
    Last Post: 11-06-2014, 10:29 AM
  6. Replies: 0
    Last Post: 05-22-2014, 11:16 AM
  7. COUNTIF Alternative for multiple criteria?
    By Dan17602 in forum Excel General
    Replies: 6
    Last Post: 03-21-2011, 12:49 PM

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