Thanks all for the help.
Juan
-----Original Message-----
"JUAN" wrote in
message
...
Hello,
I have Column C that contains about 110 different
material
groups EX, BC1,FF1,FF3,FD1, ext upto 110. I want to
create
a formula in B, which this is Sample:
=IF(OR(C:C="FI1",C:C="FI2",C:C="FM1"),"NAME1",IF(O R
(C:C="FX5",C:C="FX6",C:C="FXC",C:C="FXR"),"NAME2", IF(OR
(C:C="FV1"),"NAME3",IF(OR
(C:C="BC3",C:C="FV5"),"NAME4"))))
It works fine but when I add more IF(OR i get an error.
I'm able to have just 7-8 IF(OR so is this the Max in a
Cell?

Yes - a maximum of 7 nested IF functions in one formula.
Check out:
http://www.cpearson.com/excel/nested.htm


.