One way:

=IF(ISERROR(SEARCH("Office",AC21)),"No","Yes")

HTH,
Paul


--

wrote in message
oups.com...
when doing an IF question and I want to have the Logic Test = a single
word in the cells and have it trigger a true or false..

AC21 says "Office/Retail" i want my formula to only read the
"Office" part of it

=IF(AC21="Office","Yes","No")

I want it to still come up as "Yes" in the new cell but it wont
because cell AC21 also says "/Retail"

so the question is.. how do i get my formula to read just the "Office"
part of cell AC21??

something on the lines of "If AC21 has the word "Office" anywhere in
it then the new cell will = "Yes""