+ Reply to Thread
Results 1 to 3 of 3

"IF","OR" and "AND" help

  1. #1
    Registered User
    Join Date
    05-31-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    37

    "IF","OR" and "AND" help

    Hello, I am currently trying to figure out something for my Job. We measure the number of particles, and if the number of particles are in a certain threshold of values, we assign it a number (code). So the program I am trying to write is the following:

    -See the attachment
    -Assign a value (called "code"(column N) in the attached file) to "Code 1"(column B) if "part 1"(column J) is within bottom(column O) and top(column R).
    -Then, based on the code, I want it to write out "LOW", "MID" or "HIGH" for "Thres 1"(column F) based on where "PART 1"(column J) is within that threshold. LOW being between the Bottom threshold value and 33%, MID being between 33% and 66% and HIGH being between 66% and the top threshold.

    Any help is greatly appreciated.

    Thanks!
    Attached Files Attached Files
    Last edited by tactical; 10-06-2011 at 02:42 PM.

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: "IF","OR" and "AND" help

    In cell B2, use:

    Please Login or Register  to view this content.
    autofill through range B2:D13.

    In cell F2, use:

    Please Login or Register  to view this content.
    autofill through range F2:H13.

    You have an error in cell R7, should be 640?

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    05-31-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: "IF","OR" and "AND" help

    Quote Originally Posted by ConneXionLost View Post
    In cell B2, use:

    Please Login or Register  to view this content.
    autofill through range B2:D13.

    In cell F2, use:

    Please Login or Register  to view this content.
    autofill through range F2:H13.

    You have an error in cell R7, should be 640?

    Cheers,
    Thank you so much, and yes you are absolutely correct about that error. Thanks again!!

+ 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