Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for percentage calculation
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!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for percentage calculation
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 |
#3
|
|||
|
|||
Hi Sabir
The best solution in my opinion is the VLOOKUP function. See the attached file. Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percentage calculation | Excel Worksheet Functions | |||
Percentage Calculation | Excel Worksheet Functions | |||
Percentage calculation | Excel Discussion (Misc queries) | |||
Percentage Calculation using VBA | Excel Programming | |||
Percentage Calculation | Excel Worksheet Functions |