I have six columns where a single cell could have a value between 1 and 60. I wish to classify the result as A, B, C, D, E, or F in another column as follows:
A =between 1 & 10, B = between 11 & 20, C =Between 21 & 30, D = Between 31&40, E=between 41 & 50, F= between 51 & 60.
As an example let's assume in my 6 columns I have the following results;
Using the above description can someone help me compile a formula that would categorize my column 1-60 results into the resulting letter values as shown in the 2 examples. Thanks in advance.
A =between 1 & 10, B = between 11 & 20, C =Between 21 & 30, D = Between 31&40, E=between 41 & 50, F= between 51 & 60.
As an example let's assume in my 6 columns I have the following results;
- 8 18 27 36 44 58 the resulting analysis would be A B C D E F
- 2 9 19 22 37 41 the resulting analysis would be A A B C D E
Using the above description can someone help me compile a formula that would categorize my column 1-60 results into the resulting letter values as shown in the 2 examples. Thanks in advance.