Results 1 to 5 of 5

Multiple IF conditions in ARRAY formula

Threaded View

  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.
    Attached Files Attached Files
    Last edited by pritesh118; 06-17-2020 at 04:14 AM.

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