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

"inthestands" wrote:
> 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")

=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


--
Regards,

Peo Sjoblom


"inthestands" <(E-Mail Removed)> wrote in message
news:E7F510FC-EF0F-4D4F-B1B3-(E-Mail Removed)...
>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