Excel 2002: How to classify numbers ?
Hi Shane,
I wounder if this formula could only pick up the exact match, it won't pick
up the rage of numbers in accordance with their groupings.
Any idea ?
Thanks
Low
--
A36B58K641
"Shane Devenshire" wrote:
Hi,
You can use VLOOKUP as follows:
1. Create a lookup table like this, say in L1:M5 (it looks like you will
need more in your case)
0 A
20 B
35 C
65 D
135 E
In cell E2 enter the formula
=VLOOKUP(D2,L$1:M$5,2)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"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
|