+ Reply to Thread
Results 1 to 2 of 2

Evaluating a range using IF function

Hybrid View

  1. #1
    Registered User
    Join Date
    10-28-2014
    Location
    Jacksonville, FL
    MS-Off Ver
    7
    Posts
    1

    Evaluating a range using IF function

    Trying to evaluate cells C7:C11 to determine if the values are within the high/low limits provided in cells B16 and B17. I can get the formula to work for a single cell but need to evaluate all cells against these limits to return a single PASS/FAIL result. This is the formula that works for the single cell (C7 in this case).

    =IF(AND($B18<=C7,$B19>=C7),"PASS","FAIL")

    I have tried using C7:C11 and nesting same for each additional cell but just cant get it to work. Thanks for your help!!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,610

    Re: Evaluating a range using IF function

    Try
    =IF(and(MIN(C7:C11)>$B18,max(C7:C11)<$B19),"pass","fail")

+ 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. Function not Evaluating
    By mtnbiker98 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-09-2014, 01:33 PM
  2. Evaluating two colums in range
    By dummyaccount in forum Excel General
    Replies: 1
    Last Post: 08-13-2011, 11:11 AM
  3. Excel 2007 : Evaluating time based on a range
    By SeanMulholland in forum Excel General
    Replies: 2
    Last Post: 01-16-2010, 06:31 PM
  4. If/Then for Evaluating a Range within a Cell?
    By timkay99 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2009, 03:22 PM
  5. [SOLVED] Evaluating a Range of Empty Cells with VBA
    By John Mansfield in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2005, 05:06 AM

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