+ Reply to Thread
Results 1 to 5 of 5

Multiple IF conditions in ARRAY formula

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    London, England
    MS-Off Ver
    Office365
    Posts
    22

    Multiple IF conditions in ARRAY formula

    Hi All,

    Trying to speed up checking through data by using a single formula if possible, happy to do via macro also if easier.

    I have a set of data which contains scores for a participant over 5 different activities.

    I then have a comment column at the end, in which i would like the formula to tell me whether the participant has passed if the cells are above 50 or blank and failed if any of the cells are less than 50 and contain a number, i.e. 0.

    Pass for each activity is either above 50 or blank cell (no data)
    Fail for each activity is between 0 and 49

    See attached data set for example to work with.

    Thanks in advance.
    Last edited by pritesh118; 06-17-2020 at 04:14 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Multiple IF conditions in ARRAY formula

    How about
    =IF(COUNTIFS(D4:H4,"<50")>0,"Fail","Pass")

  3. #3
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Multiple IF conditions in ARRAY formula

    In K2:
    =IF(SUM((D4:H4<49)*(D4:H4<>""))>0,"Fail","pass")

    ***Array formula, entered with CTRL+SHIFT+ENTER

  4. #4
    Registered User
    Join Date
    05-21-2013
    Location
    London, England
    MS-Off Ver
    Office365
    Posts
    22

    Re: Multiple IF conditions in ARRAY formula

    Tried this and it worked a treat, thanks Fluff13.

    Belinda will keep your version handy as well, thanks.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Multiple IF conditions in ARRAY formula

    Glad we could help & thanks for the feedback.

+ 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] Array formula with multiple conditions
    By lexusap in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-13-2017, 01:57 AM
  2. [SOLVED] [SOLVED] Array formula to sum items that meet multiple conditions
    By TPDave in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-07-2014, 08:16 AM
  3. I am trying to write an array with multiple if conditions
    By kishoremcp in forum Excel General
    Replies: 1
    Last Post: 01-24-2012, 11:20 AM
  4. Array formula to count based on multiple conditions
    By markrennolds in forum Excel General
    Replies: 1
    Last Post: 11-09-2010, 05:56 PM
  5. SUMIF or an array formula - matching multiple conditions
    By Jason_2112 in forum Excel General
    Replies: 2
    Last Post: 01-14-2009, 06:03 PM
  6. array formula with multiple conditions
    By neowok in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-02-2007, 03:06 PM
  7. Array Formula With Multiple Conditions
    By JR573PUTT in forum Excel General
    Replies: 3
    Last Post: 02-16-2006, 07:37 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