+ Reply to Thread
Results 1 to 4 of 4

Expanding on an If And formula

  1. #1
    Registered User
    Join Date
    10-09-2016
    Location
    Preston, England
    MS-Off Ver
    2010, 2013 & 2016
    Posts
    30

    Question Expanding on an If And formula

    I have an if and formula =IF((AND(A2>=32, B2>=32)), "Y", "N")
    I want to expand on this.

    In the test document linked the if and formula is in reference to the first two columns. I would also like this if and formula to look through the range C2:N2 and return Y if five or more numbers are >=32 and N if not. so the whole formula returns Y if A2>=32 and B2>=32 and if 5 or more out of C2:N2>=32. (if that makes sense).
    The formula needs to be in O2

    Thanks in advance
    Jon
    Attached Files Attached Files
    Last edited by Jwilf; 10-13-2016 at 03:59 PM. Reason: SOLVEd

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Expanding on an If And formula

    Is the A2 and B2 >=32 a SEPARATE requirement from the C2:N2>32 >=5?

    Does this do what you want:

    =IF(AND(A2>=32,B2>=32,COUNTIF(C2:N2,">=32")>=5),"Y","N")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    10-09-2016
    Location
    Preston, England
    MS-Off Ver
    2010, 2013 & 2016
    Posts
    30

    Re: Expanding on an If And formula

    That works perfectly

    Thank you for the quick response.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Expanding on an If And formula

    You're welcome. 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] Expanding a complex IF/AND formula
    By kamylka13 in forum Excel General
    Replies: 11
    Last Post: 05-15-2016, 02:21 PM
  2. Expanding Formula
    By cfieser in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-02-2013, 01:33 PM
  3. expanding an IF formula
    By tvonbehren in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-30-2009, 03:20 PM
  4. Expanding on a formula
    By MartinW in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-20-2006, 08:10 AM
  5. Expanding Formula Bar
    By Domingo in forum Excel General
    Replies: 4
    Last Post: 12-25-2005, 08:34 PM
  6. [SOLVED] Need an Expanding array formula
    By havocdragon in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-05-2005, 06:05 AM
  7. Help With Expanding A Formula
    By Minitman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-18-2005, 02:06 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