Thread: columns_if
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default columns_if

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

--
__________________________________
HTH

Bob

"Alexandra Lopes" wrote in message
...
Hello,

I have a column with names. In 3 columns to follow, I have these names
distributed for the 3 columns: Bad, Mediums and Good.

I intend that in one another column appears I - if the name is in the
column Bad, C - if the the name is in column Mediums and S - if the name
is in the column Good.

Thanks in advance!