Home 
Search 
Today's 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! 
#2




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 Downloads:25,000 Files:300 Subscribers:70 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! 
#3




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+(a11000)*.26,if(a1<=5000,510+(a12000)*.28,1050+(a15000)*.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! 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
CALCULATE GST AMOUNT FROM AMOUNT IN OTHER CELL  Excel Worksheet Functions  
How can I calculate amount of time left based on amount spent?  Excel Worksheet Functions  
Calculate gross profit based on varying percentages  Excel Worksheet Functions  
calculating different percentages depending on amount  Excel Discussion (Misc queries)  
How do I calculate Amount of Sales Tax from Total Amount?  Excel Worksheet Functions 