Thread: change "true" and "false" to "availble" and "out of stock"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
  
Posts: 418
Default change "true" and "false" to "availble" and "out of stock"
"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")
Reply With QuoteReply With Quote