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!
|