Sabir

Junior Member

Posts: 2

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 07:05 PM
Percentage Calculation using VBA	Peter	Excel Programming	4	November 7th 05 11:06 AM
Percentage Calculation	clandis	Excel Worksheet Functions	5	July 21st 05 07:38 PM

All times are GMT +1. The time now is 12:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us