Nested IF error
 

It would help if you would let us know what you're trying to do.
What you have here are a couple of problems, first you're testing L2 for
"I", but if that's true, then you're testing for "R"? it can't be both. I
think you left out a value if true here.
Your next problem is with this:
if(OR(N2="Ex",S2<"IA"),N2="COS",N2="CO",S2="L")," D","W")
specificallly this part:
OR(N2="Ex",S2<"IA"),N2="COS",N2="CO",S2="L")
what were you intending to test here? If it could be anyone of those and be
true then you have an extra ) after "IA".
With those two corrections you would get a workable formula, but we need
more info if it isn't what you wanted:
=IF(L2="I","True Value
Here",IF(L2="R","B",IF(L2="F","Ro",IF(L2="SCA","Ri ",IF(OR(S2="IA",N2="GBS"),"GN",IF(AND(L2="HC",OR(N 2="Fi",N2="In",N2="XC")),"OM",IF(OR(N2="Ex",S2<"I A",N2="COS",N2="CO",S2="L"),"D","W")))))))


"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