You have answers to your post in the worksheet function ng. What is your
response to bj's suggestion?

Greg Wilson

"kd" wrote:

Hi,
Any help in the error below would be greatly appreciated.

=if(L2="I",if(L2="R","B",IF(L2="F","Ro",if(L2="SCA ","Ri",if(or(S2="IA",N2="GBS"),"GN",if(AND(L2="HC" ,or(N2="Fi",N2="In",N2="XC")),"OM",if(OR(N2="Ex",S 2<"IA"),N2="COS",N2="CO",S2="L"),"D","W")))))))

Thanks in advance.
KD