Thread: How do I handle error conditions with the FIND command?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default How do I handle error conditions with the FIND command?
"Dave Peterson" wrote...
=if(isnumber(find(...)),"it's there","it's not there")
....

Can save a few keystrokes using COUNT instead of ISNUMBER.

=IF(COUNT(FIND(..)),"found","not found")


Reply With QuoteReply With Quote