change "true" and "false" to "availble" and "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" wrote in message
...
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
|