ExcelBanter - Formula for percentage calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula for percentage calculation (https://www.excelbanter.com/excel-discussion-misc-queries/448206-formula-percentage-calculation.html)

Sabir

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!!!

Claus Busch

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

Kevin@Radstock

1 Attachment(s)

Hi Sabir

The best solution in my opinion is the VLOOKUP function. See the attached file.

Kevin

Quote:

Originally Posted by Sabir (Post 1609478)

All times are GMT +1. The time now is 03:59 AM.