+ Reply to Thread
Results 1 to 6 of 6

Evaluating Each Cell

  1. #1
    Forum Contributor
    Join Date
    05-18-2004
    Location
    Portland, Oregon
    MS-Off Ver
    2016
    Posts
    182

    Evaluating Each Cell

    Hi Everyone,

    I have what seems to be a simple problem, yet it is stumping me.

    I need to be able to evalue a range of cells for two conditions.
    Condition 1: Value greater than or equal two 600
    Condition 2: Okay for value to be equal to zero or blank
    If both conditions are not met in one cell, the whole row fails.

    Each cell in the range needs to be evaluated for these conditions.

    Here is the layout.
    A B C D
    1 200 600 1 Failed
    2 600 600 700 Passed
    3 0 700 900 Passed

    I was looking at a formula for Column D using nested IF statements, but couldn't get them to work (1>Value>600). The other complication is that we could end up evaluating up to 12 data points for each row...which violates the nested IF statement limits.

    Ideas?

    Thanks,
    Matt
    Last edited by matt4003; 03-15-2011 at 08:16 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,163

    Re: Evaluating Each Cell

    Hi Matt,

    Try this
    Please Login or Register  to view this content.
    If you are testing more than 3 columns, change the 3 to more and of course make the range of cells larger.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    05-18-2004
    Location
    Portland, Oregon
    MS-Off Ver
    2016
    Posts
    182

    Re: Evaluating Each Cell

    Hello Marvin,

    Many thanks for the quick reply!

    I tried your suggestion, but it doesn't seem to handle blank or 0 as an acceptable value.

    Thanks again!
    Matt

  4. #4
    Forum Contributor
    Join Date
    05-18-2004
    Location
    Portland, Oregon
    MS-Off Ver
    2016
    Posts
    182

    Re: Evaluating Each Cell

    Hi All,

    I have attached an example file.

    Maybe this will help.

    Thanks,
    Matt
    Attached Files Attached Files

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,163

    Re: Evaluating Each Cell

    Hi Matt,
    Try this one then:
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    05-18-2004
    Location
    Portland, Oregon
    MS-Off Ver
    2016
    Posts
    182

    Re: Evaluating Each Cell

    Many thanks Marvin! Works great in this example. Will need to check how many columns I can go out, but it seems to do what I need it to do!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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