Thread: columns_if
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alexandra Lopes Alexandra Lopes is offline
external usenet poster
  
Posts: 35
Default columns_if
Bob Phillips wrote:
This is simpler

=IF(B2<"";"I",IF(C2<"";"C",IF(D2<"";"S";"")))

or even

=CHOOSE(MATCH(A2;B2:D2;0);"I";"C";"S")



This results!

Thank you very much!
Reply With QuoteReply With Quote