Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Question 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default 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   Report Post  
Member
 
Posts: 93
Default

Hi Sabir

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

Kevin


Quote:
Originally Posted by Sabir View Post
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!!!
Attached Files
File Type: zip 007-Formula for percentage calculation.zip (8.6 KB, 38 views)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
percentage calculation sumesh56 Excel Worksheet Functions 5 October 16th 12 05:47 PM
Percentage Calculation Chris Excel Worksheet Functions 7 September 3rd 09 12:36 PM
Percentage calculation Roz Excel Discussion (Misc queries) 5 January 6th 06 08:05 PM
Percentage Calculation using VBA Peter Excel Programming 4 November 7th 05 12:06 PM
Percentage Calculation clandis Excel Worksheet Functions 5 July 21st 05 07:38 PM


All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"