Thread: columns_if
View Single Post
  #9   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

It was my use of commas that was the problem, your Excel requires
semi-colons as separators.

--
__________________________________
HTH

Bob

"Alexandra Lopes" wrote in message
...
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!