Lookup ?

[Graham]

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

 

[Jacob Skaria]

With the lookup value in C1 try the below formula. Format the cell to
percentage

=LOOKUP(C1,{0,10000,15000,20000,30000,40000,50000},{0,10,20,30,40,50,60})%

If this post helps click Yes

 

[Eduardo]

\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(AND(C1>=14000,C1<20000),0.2,IF(AND(C1>=20000,C1<30000),0.3,IF(AND(C1>=30000,C1<40000),0.4,IF(AND(C1>=40000,C1<50000),0.5,IF(C1>=50000,0.6,"")))))))

 

[Graham]

Thanx Eduardo,worked great!!

 

[Graham]

worked great thanx a mill!!
--
Eager to learn !

With the lookup value in C1 try the below formula. Format the cell to
percentage

=LOOKUP(C1,{0,10000,15000,20000,30000,40000,50000},{0,10,20,30,40,50,60})%

If this post helps click Yes