Junior Member

Posts: 2

Formula for calulating percentage

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
Linear Mode Switch to Hybrid Mode Switch to 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
Calulating future Age	Ginabops	Excel Worksheet Functions	2	June 1st 12 03:59 AM
Help with calulating Null fields	Roderic	Excel Worksheet Functions	3	August 11th 08 10:29 PM
Calulating week # & Day #	bj[_2_]	Excel Worksheet Functions	2	May 4th 07 02:48 PM
reducing Calulating time	harpscardiff	Excel Discussion (Misc queries)	1	March 14th 06 12:26 PM
Calulating Age Formula	YUMBUG	Excel Worksheet Functions	3	August 26th 05 01:25 AM

All times are GMT +1. The time now is 08:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us