change "true" and "false" to "availble" and "out of stock"

I

inthestands

i am using a search formula =(NOT(ISERROR(SEARCH(C$1,A2)))) which returns a
true or false answer. I would like it to return answers of Available instead
of TRUE and out of stock for FALSE. How would I change the formula to do
this?

Thanks in advance,
inthestands
 
J

joeu2004

inthestands said:
i am using a search formula =(NOT(ISERROR(SEARCH(C$1,A2))))
which returns a true or false answer. I would like it to return
answers of Available instead of TRUE and out of stock for FALSE.

=if(not(iserror(search(C$1,A2))), "Available", "Out of Stock")
 
P

Peo Sjoblom

=IF(ISNUMBER(SEARCH(C$1,A2)),"Available","Out of stock")


NOT(ISERROR())

is the same as ISNUMBER()

for the search/find functions

but it is less to write and one less function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top