Any suggestion on this would be greatly appreciated.
I am getting an error while running this formula, can't figure out where am
I missing.

=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.
KD

you are missing the true responce for the initial "L2="I"" statement
and in the the last if statement, you may need another "and" or "or" in the
logical statement or you may need to get rid of the ")" after "IA"

"kd" wrote:

Any suggestion on this would be greatly appreciated.
I am getting an error while running this formula, can't figure out where am
I missing.

=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.
KD

I think you have one too many closed brackets ')' and you are going over the
limit of 7 nested functions

--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"kd" wrote:

Any suggestion on this would be greatly appreciated.
I am getting an error while running this formula, can't figure out where am
I missing.

=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.
KD