Excel 2002: How to classify numbers ?
Hi Jacob,
Thanks for the first formula.
What about the formula with "greater or equal" and "less or equal" as
illustrated below:
Group defination:
0 =< A <= 20
21 =< B <= 35
36 =< C <= 65
66 =< D <=135
136 =< E
Thanks
Low
--
A36B58K641
"Jacob Skaria" wrote:
In E2 copy the below formula
=LOOKUP(D2,{0,1,20,35,65,135},{"","A","B","C","D", "E"})
If this post helps click Yes
---------------
Jacob Skaria
"Mr. Low" wrote:
Hi,
Lets consider the folowing table:
A B C D E
1 Invoice Date Amount Days Old Group
2 B21 21.5.09 200 60 C
3 yyy 30 B
15 A
120 D
360 E
450
245
Group defination:
0 < A < 20
20 < B < 35
35 < C < 65
65 < D <135
135 < E
The group classification is a range where the number of days lies.
May I know the formula for cell E2 that enable me to get the answers when
copy downwards ?
Thanks
Low
--
A36B58K641
|