Use:

=CHAR(MIN(MAX(INT(16-A1/5000),1),13)+64)

to obtain:

99,000 A
67,500 B
62,500 C
57,500 D
52,500 E
47,500 F
42,500 G
37,500 H
32,500 I
27,500 J
22,500 K
17,500 L
12,000 M

--
Gary's Student


"girth69" wrote:


The CHAR function looks pretty good. if i type the complete list of
catergories could you please give me the required formula. Thanks,

exceeding 70,000 A
65,000 €“ 70,000 B
60,000 €“ 65,000 C
55,000 €“ 60,000 D
50,000 - 55,000 E
45,000 €“ 50,000 F
40,000 €“ 45,000 G
35,000 €“ 40,000 H
30,000 €“ 35,000 I
25,000 €“ 30,000 J
20,000 €“ 25,000 K
15,000 €“ 20,000 L
less than 15,000 M


--
girth69
------------------------------------------------------------------------
girth69's Profile: http://www.excelforum.com/member.php...o&userid=23634
View this thread: http://www.excelforum.com/showthread...hreadid=569861