# Thread: More Nested IF/OR help needed

1. Registered User
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. Registered User
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")))

3. Registered User
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. Registered User
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")))

#### Posting Permissions

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