Nested IF formulas

[dowcraig]

Good afternoon,
I'm trying to create a nested formula in cell Y1 that will return the values of HIGH or LOW depending on a few criteria.

1) First off - I want the cell to return a blank value of nothing applies
2) Looking to have the value of HIGH or LOW returned depending on if the value in cell X1 is greater than 59%
3) Looking o have the value of HIGH returned if the contents of cell W1 is either "Dog", Cat" or Bird"

This is what I've come up with, but it's not working:
=IF(OR(ISNUMBER(SEARCH("Dog",W1)),ISNUMBER(SEARCH("Cat",W1)),ISNUMBER(SEARCH("Bird",W1))),"HIGH","LOW"),IF(X1="","",IF(X1>59%,"HIGH","LOW"))

Any help you can provide would be appreciated. Thank you.

 

[etaf]

=if(OR(W1="dog",W1="cat",W1="bird"), "High", "low")

I dont understand the point 2)

is it High if X1 is greater than 59% otherwise its LOW
and so how would 1 work - as there willl never be a condition that nothing apples unless i suppose if X1 = blank

=if(OR(W1="dog",W1="cat",W1="bird", X1>0.59), "High", if(X1="","","low"))

 

[dowcraig]

That works great. Thank you.

One problem that is presenting itself is that we can choose multiple items in W1, which is a drop down list(we could choose dog and cat) and when that happens, no value is returned.

 

[etaf]

what are all the options

dog
cat
bird
what else is in the cell

are seen differently

is that why you did a search ?

 

[dowcraig]

There is a list of 13 options. Let's call them:

Bird
Dog
Cat
Fish
Seagull
Dingo
Rat
Mouse
Racoon
Monkey
Rabbit
Cow
Horse

The first 3 are considered high probability animals and we need to return a HIGH result in the cell with the formual. The last 8 are irrelevant, other than providing the reader with some information. But, the problem is that ALL 11 can be chosen at the same time and when that happens, or even just 2 of them happens, it's not returning HIGH if one of, or multiple of the first three are chosen.

 

[etaf]

how can they all be chosen in one cell

 

[dowcraig]

how can they all be chosen in one cell

With a marco