Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF error | Excel Discussion (Misc queries) | |||
Nested IF error | Excel Discussion (Misc queries) | |||
3 nested IFs causes error | Excel Worksheet Functions | |||
If and nested Sumif error | Excel Worksheet Functions | |||
Nested IF error | Excel Worksheet Functions |