C
Cerberus
I have 2 different products with 7 options each and I was trying to put them
into 6 categories. The products are "TOP HINGE" and "OFFSET TOP HINGE" and
they each have an option of "O EXT", "12 EXT", "18 EXT", "24 EXT", "30 EXT",
"36 EXT", "48 EXT". Now I am trying to give "TOP HINGE-0 EXT" a value of 1,
"TOP HINGE-12 EXT" a value of 2, and "TOP HINGE-18 EXT" on up a value of 3
and "OFFSET TOP HINGE" option follows that same pattern.
I used =IF(M52="TOP HINGE-0 EXT",1,IF(M52="TOP HINGE-12
EXT",2,IF(AND(M52="TOP HINGE-18 EXT",M52="TOP HINGE-24 EXT",M52="TOP HINGE-30
EXT",M52="TOP HINGE-36 EXT",M52=TOP HINGE-48 EXT"),3,IF(M52="OFFSET TOP
HINGE-0 EXT",4,IF(M52="OFFSET TOP HINGE-12 EXT",5,IF(AND(M52="OFFSET TOP
HINGE-18 EXT",M52="OFFSET TOP HINGE-24 EXT",M52="OFFSET TOP HINGE-30
EXT",M52="OFFSET TOP HINGE-36 EXT",M52=OFFSET TOP HINGE-48 EXT"),6,0))))))
But it seems to be too many functions or I missed something. Is there any
help for this? I definitely appreciate any help.
Thank you in advance.
into 6 categories. The products are "TOP HINGE" and "OFFSET TOP HINGE" and
they each have an option of "O EXT", "12 EXT", "18 EXT", "24 EXT", "30 EXT",
"36 EXT", "48 EXT". Now I am trying to give "TOP HINGE-0 EXT" a value of 1,
"TOP HINGE-12 EXT" a value of 2, and "TOP HINGE-18 EXT" on up a value of 3
and "OFFSET TOP HINGE" option follows that same pattern.
I used =IF(M52="TOP HINGE-0 EXT",1,IF(M52="TOP HINGE-12
EXT",2,IF(AND(M52="TOP HINGE-18 EXT",M52="TOP HINGE-24 EXT",M52="TOP HINGE-30
EXT",M52="TOP HINGE-36 EXT",M52=TOP HINGE-48 EXT"),3,IF(M52="OFFSET TOP
HINGE-0 EXT",4,IF(M52="OFFSET TOP HINGE-12 EXT",5,IF(AND(M52="OFFSET TOP
HINGE-18 EXT",M52="OFFSET TOP HINGE-24 EXT",M52="OFFSET TOP HINGE-30
EXT",M52="OFFSET TOP HINGE-36 EXT",M52=OFFSET TOP HINGE-48 EXT"),6,0))))))
But it seems to be too many functions or I missed something. Is there any
help for this? I definitely appreciate any help.
Thank you in advance.