Hi Sabir
The best solution in my opinion is the VLOOKUP function. See the attached file.
Kevin
Quote:
Originally Posted by 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!!!
|