Mike/Greg/Boni,

Thanks so much for your time. After viewing your responses, I played with
the formula a few more times and got the result/s I was looking for, here is
the one giving correct result.

=IF(H2="I","W",IF(H2="R","B",IF(H2="F","Ro",IF(H2= "SCA","Ri",IF(OR(N2="IA",I2="GBS"),"GN",IF(AND(H2= "HC",OR(I2="Fi",I2="In",I2="XC")),"OM",IF(OR(I2="E x",N2<"IA",I2="COS",I2="CO",N2="L"),"D",FALSE)))) )))

Thanks again for looking into my problem.
KD

"BoniM" wrote:

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