Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: More Nested IF/OR help needed

    Hi,

    I have a value in Cell 1 that I need to check in numerous ways (including against another cell) and then have some text displayed in the cell where the checking is done.

    If the value in Cell 1 is >=.2 or Cell 2 = "YES" then Cell 3 needs to display "PD"

    If the value in Cell 1 is <=-0.3 then cell 3 needs to display "PR"

    If the value in Cell 1 is <=-0.1 then cell 3 needs to display "CR"

    If the Value in Cell 1 doesn't meet any of the criteria above then display "SD"

    This is what I have started with but something is not right:
    =IF((OR(D31="YES",D29>=0.2)),"PD",(OR((D29<=-0.3),"PR",(OR((D29<-1),"CR","SD")))))

    But I am getting a value error in Cell 3. Any Help would be greatly appreciated. Thanks in Advance.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    See if this is what you need:

    =IF(OR(D31>=0.2,D29="Yes"),"PD",IF(C31<=0-3,"PR",IF(C31<=-1,"CR","SD")))
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2004
    Posts
    7
    I actually think I have screwed up the below formulas - maybe someone can help - I am dealing with a negative numbers:

    if the value in cell 1 = -1.0 and lower (i.e. -2.0) then "CR" should display in cell 3

    If the value in cell 1 = .99 through .30 then "PR" should display in cell 3

    If the value in cell 1 = .29 through .21 then "SD" should display in cell 3

    If the value in cell 1 = .20 and higher then "PD" should display in cell 3.

    Thanks again - this is driving me crazy. As an FYI I am working on a calculator to track cancer tumor size increase/decrease. So the Value in cell 1 is the precentage of decrease from the baseline size.

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Try this

    =IF(D31<=-1,"CR",IF(OR(C31>-1,C31<=-0.3),"PR",IF(OR(C31>-0.3,C31<=-0.2),"SD","PD")))
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •