Thread: Combining IF statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Macmo
 
Posts: n/a
Default Combining IF statements
I need to combine multiple IF statements such as

=IF("Debbie"=Kim!B4:H18,"Kim","")
=IF("Debbie"=Bob!B4:H18,"Bob","")
=IF("Debbie"=Joe!B4:H18,"Joe","")

or an easier "statement" to use? I have roughly 15 of these I need to
combine.

Reply With QuoteReply With Quote