Remember Me?

 Amaren external usenet poster First recorded activity by ExcelBanter: Jun 2009 Posts: 1 Calculate Amount with Varying Percentages per Thousands

Does anyone know how to write a formula that would update my compensation
number based on the following:

I get 25% of the first \$1,000
Then 26% of \$1,001 to \$2,000
Then 28% of \$2,000 to \$5,000

I want to be able to update the amount I made for my company (i.e. \$12,355)
in one cell and then have a formula that would calculate my bonus based on
those percentages per thousand in another cell?
I am rusty on my formula writing and need some help!!!
Thanks!

 Max external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 9,221 Calculate Amount with Varying Percentages per Thousands

Try JE's:
http://www.mcgimpsey.com/excel/variablerate.html
Using SUMPRODUCT() to calculate variable rates and commissions
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Amaren" wrote:
Does anyone know how to write a formula that would update my compensation
number based on the following:

I get 25% of the first \$1,000
Then 26% of \$1,001 to \$2,000
Then 28% of \$2,000 to \$5,000

I want to be able to update the amount I made for my company (i.e. \$12,355)
in one cell and then have a formula that would calculate my bonus based on
those percentages per thousand in another cell?
I am rusty on my formula writing and need some help!!!
Thanks!

 Fred Smith[_4_] external usenet poster First recorded activity by ExcelBanter: Jan 2008 Posts: 2,389 Calculate Amount with Varying Percentages per Thousands

How much do you get for sales over \$5,000? The following formula assumes
30%, but change it to what you need. Assuming the sales amount (12,355) is
in a1:
=if(a1<=1000,a1*.25,if(a1<=2000,250+(a1-1000)*.26,if(a1<=5000,510+(a1-2000)*.28,1050+(a1-5000)*.30)))

Regards,
Fred

"Amaren" wrote in message
...
Does anyone know how to write a formula that would update my compensation
number based on the following:

I get 25% of the first \$1,000
Then 26% of \$1,001 to \$2,000
Then 28% of \$2,000 to \$5,000

I want to be able to update the amount I made for my company (i.e.
\$12,355)
in one cell and then have a formula that would calculate my bonus based on
those percentages per thousand in another cell?
I am rusty on my formula writing and need some help!!!
Thanks!

 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 OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Cruisie Suzie Excel Worksheet Functions 1 October 27th 08 08:51 AM KLD Excel Worksheet Functions 3 May 23rd 06 04:20 PM Pasko1 Excel Worksheet Functions 2 May 4th 06 03:14 AM pgruening Excel Discussion (Misc queries) 6 October 24th 05 05:57 PM MikeS Excel Worksheet Functions 1 March 26th 05 08:49 PM

All times are GMT +1. The time now is 09:18 PM. Copyright ©2004-2019 ExcelBanter.