Hi Karen,

Try this ...

=IF(A1="YNNNYYNN","ClassA",IF(A1="NNYYYNNN","ClassB",IF(A1="NNNNNNNY","ClassB","")))

SUB-ZERO


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-