Formula Quandary - I'm Stumped!

[DA7135X]

I am trying to enter a formula that will not only give a specifi
response if the quantity is over/under a certain amount, but also leav
the field blank if a certain text message appears in the cell. I nee
to combine the two formulas listed below, but, so far, I have had n
luck.
*
I can get this formula to work on it's own
=IF(OR(D89>129,D80=20,D64=20,D48=30),"X"," ")
*
Does the following:
I need the cell to have an "X" in it if the following is true:
- If total is greater than 129
- If question 6 = 30 pts
- If question 8 = 20 pts
- If question 10 = 20 pts
*
but, I can't get the cell to be blank if the following text appears i
the total cell (D89). Again, I can get it to work on it's own, but no
in conjunction with the above formula:
*
=IF(OR(D89="PLEASE SELECT AN ANSWER FOR ALL YELLOW BOXES IN COLUM
C")," "," ")
:confused

 

[Peo Sjoblom]

One way

=IF(ISNUMBER(SEARCH("PLEASE SELECT AN ANSWER FOR ALL YELLOW BOXES IN COLUMN
C",D89)),"",IF(OR(D89>129,D80=20,D64=20,D48=30),"X",""))

The reason I used isnumber is because I don't know how the text would get to
D89, if it is from a formula you can just use

=IF(D89="PLEASE SELECT AN ANSWER FOR ALL YELLOW BOXES IN COLUMN
C","",IF(OR(D89>129,D80=20,D64=20,D48=30),"X",""))

 

[Don Guillett]

just try
=if(d89="blah","",=IF(OR(D89>129,D80=20,D64=20,D48=30),"X"," "))

 

[DA7135X]

Dear Peo and Don,
Thank you both for your replies. Unfortunately, I'm still getting an
"X" in the box when all there is in the cell is the text. Any other
ideas?
Thanks again,
Lynda

 

[Don Guillett]

The formula I sent you does work with one minor correction. chenge
=if(d89="blah","",=IF(OR(D89>129,D80=20,D64=20,D48=30),"X"," "))

to this to remove the unwanted = sign. I have even included your "blah"

=if(d89="PLEASE SELECT AN ANSWER FOR ALL YELLOW BOXES IN COLUMN
C","",IF(OR(D89>129,D80=20,D64=20,D48=30),"X"," "))