Thread: Replacing one text with three in IF(ISERROR(FIND.......Max
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
  
Posts: 1,814
Default Replacing one text with three in IF(ISERROR(FIND.......Max
I have this formula.

=IF(ISERROR(FIND("Relief",MasterTab!O21)),"",MAX(A $1:A1)+1)

can it be modified to find three different things instead of "relief". I'd
like it to find: (FLM) (FL) and (M) ?

Much thanks,

Steve
Reply With QuoteReply With Quote