hi all,
I am trying to categorize two digit sic-codes (industry of a company) into their major industry group.
the numbers for my two digit sic codes range from 0-99.
I want to categorize them in the following groups
Sic codes from
1-9 = 1
10-14 = 2
15-17 =3 etc...
20-39
40-49
50-51
52-59
60-67
70-89
90-97
99
i tried the if-function like this:
=if(E2<10;1;if(9<E2<15;2;if(14<E2<18;3;if(19<E2<40;4;if(39<E2<50;5;if(49<E2<52;6;IF(51<E2<60;7;if(59<E2<68;8;if(69<E2<90;9;if(90<E2<98;10;if(E2=99;11;"Kan niet")))))))))))
But unfortunately it does not work. Can anyone help me with this issue? Thanks!
Bookmarks