need a formula please

[TAKTOUKA]

A B C
0 15000 10%
15001 35000 15%
35001 20%


I need a formula to calculate 10 % for whose who takes salary less than
15000 and 15% for the salary range between 15001 and 35000 and 20% for
those who takes salary greater than 35001 .

 

[Bob Phillips]

=A20*LOOKUP(A20,{0,0.1;15000,0.15;35000,0.2})

 

[Mangesh Yadav]

=IF(A10<=B1,C1,IF(A10<=B2,C2,C3))

for a salary entered in A10

Mangesh