Thread: If - additional criteria
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
suddengunfire suddengunfire is offline
external usenet poster
  
Posts: 10
Default If - additional criteria
Something like

=IF((a1=1),"AB",IF((a1=2),"BA","CA"))

but I need more than one criteria for "AB"
Reply With QuoteReply With Quote