Thread: change "true" and "false" to "availble" and "out of stock"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
inthestands inthestands is offline
external usenet poster
  
Posts: 15
Default change "true" and "false" to "availble" and "out of stock"
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
Reply With QuoteReply With Quote