Thanx Eduardo,worked great!!
--
Eager to learn !


"Eduardo" wrote:

\Hi,
I assume you enter the value in cell C1 and want the % to be populated in
cell D1, so in D1 enter

=IF(C1<10000,0,IF(AND(C1=10000,C1<14000),0.1,IF(A ND(C1=14000,C1<20000),0.2,IF(AND(C1=20000,C1<300 00),0.3,IF(AND(C1=30000,C1<40000),0.4,IF(AND(C1= 40000,C1<50000),0.5,IF(C1=50000,0.6,"")))))))


"Graham" wrote:

Hi I have something like this:

A B
0-9999 0%
10000-14999 10%
15000-19999 20%
20000-29999 30%
30000-39999 40%
40000-49999 50%
50000- 60%

I NEED A FORMULAE TO GIVE ME THE % IN COLUMN B WHEN VALUE IS WITHIN THE
RANGE IN COLMN A.

THANKS
GRAHAM
--
Eager to learn !