Looking for a multiple IF statement

[JBClaypool]

Let's say there are 3 columns. Column A is blank, B either contains 1, 2, 3, 4, or something else, and C will have either contain "pool" or nothing.
I'm looking for some kind of statement that will do the following for column A:
if col B is not 1, 2, 3, or 4, then print "number"
if col C contains the text "pool" then print "pool"

So, basically, I want Column A to print "number" if the numbers '1', '2', '3', or '4' don't appear in column B, and I want it to print "pool" if the cell in Column C contains the word "pool" If Col B and Col C don't contain either of the values, then print no information at all.

Thoughts?

[Ace_XL]

Try

=IF(NOT(ISNUMBER(B1)),"number",IF(C1="pool",C1,""))

[JBClaypool]

Thank you. It's a good start, but the "pool" part doesn't work. There are times when "pool" is in the cell, but there are other words, too. It could contain something like "jerry's pool" frequently.

[Ace_XL]

In that case..

=IF(NOT(ISNUMBER(B1)),"number",IF(ISNUMBER(SEARCH("pool",C1)),"pool",""))

[JBClaypool]

This is what I'm looking for. Who knew it was so simple! I feel so... d'oh!
Thanks!

[JBClaypool]

hey, if there is existing text in the cell that I am entering the code in, is there a way that text can stay?

In other words, if "cement" is in one of the cells in Col A, is there a way to keep "cement" in there even if "pool" or "1, 2, 3, or 4" is in Col B or C?

[JBClaypool]

I figured out a nice little way to get it to work

IF(ISNUMBER(SEARCH("cemenet",a:a)),"cement",IF(NOT(OR(b:b=1,b:b=4,b:b=6,b:b="none",M:M="")),"work",VLOOKUP(c:c,Sheet1!A:C,2,FALSE)))

Thanks for showing me the way!