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"),"NA ME4"))))
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?
I think I need about 24 IF(OR . The file that I open
might not include all groups, but changes. So my data file
might contain some groups this month but not all. So when
I do the formula, I want to be able to look for all groups.
Any help would be very greateful.
Thanks,
JUAN