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