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;50 0,1.08;600,1.07;900,1.06},2,1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2