Formula for percentage calculation

[Sabir]

i have values 0-5000
i want to add percentage to the value as follows
less than 100 - 25%
100-300 -20%
300-400 -15%
400-500 -10%
500-600 -8%
600-900 -7%
above 900 -6%

can anyone help me to put a formula to calculate this.please!!

 

[Claus Busch]

hi,

Am Tue, 19 Feb 2013 07:32:12 +0000 schrieb Sabir:

i have values 0-5000
i want to add percentage to the value as follows
less than 100 - 25%
100-300 -20%
300-400 -15%
400-500 -10%
500-600 -8%
600-900 -7%
above 900 -6%

try:
=A1*VLOOKUP(A1,{0,1.25;100,1.2;300,1.15;400,1.1;500,1.08;600,1.07;900,1.06},2,1)


Regards
Claus Busch