=IF(NOT(G2),IF(OR(F2={"cat","dog","mouse"}),"pet", "wild"))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mary s" wrote in message
...
I'm trying to create a formula to test multiple situations. I have a mock
up
of my spreadsheet below:

Col F: data i'm testing
Col G: Test One--I have a nested IF formula here that turns out either a
"TRUE" or "FALSE".
Col H: Test Two--I want to build a conditional formula to test that if the
test in Col. G results in "FALSE" then it references the data in Col. F
and
for all items "dog" "cat" "mouse" in the same row(from Col. F) then it
returns with "pet". If the data in Col. G is "FALSE" but the data in the
same row in Col. F is not "dog" "cat" or "mouse" the return should be
"wild".

Ultimately I would like to only have one column that tests 9 conditions
and
has 3 different value outputs, but I think that it is easier for me to
build
two columns and split the test.

If anyone has any ideas I would really appreciate it!