Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-20-2011, 02:51 PM
grs grs is offline What formula should I use to calculate commission? Windows XP What formula should I use to calculate commission? Office 2000
Novice
What formula should I use to calculate commission?
 
Join Date: Feb 2011
Posts: 3
grs is on a distinguished road
Default What formula should I use to calculate commission?

I would like my spreadsheet to calculate the commission costs on a product.



Up to 25000 commission is charged at a rate of 1.5% then at .75% after that.

Lets say cell A1 has 56300 I would like cell A3 to display the total commission rate on the number is cell A1.

What formula should I use to generate this result?
Reply With Quote
  #2  
Old 02-20-2011, 03:42 PM
Kimberly Kimberly is offline What formula should I use to calculate commission? Windows 7 What formula should I use to calculate commission? Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Put .015 in cell D1
Put .0075 in E1

=IF(A1<=25000,A1*$D$1,25000*$D$1+(A1-25000)*$E$1)
Reply With Quote
  #3  
Old 02-20-2011, 03:53 PM
grs grs is offline What formula should I use to calculate commission? Windows XP What formula should I use to calculate commission? Office 2000
Novice
What formula should I use to calculate commission?
 
Join Date: Feb 2011
Posts: 3
grs is on a distinguished road
Default

Thanks for that.
Reply With Quote
  #4  
Old 02-21-2011, 02:17 AM
grs grs is offline What formula should I use to calculate commission? Windows XP What formula should I use to calculate commission? Office 2000
Novice
What formula should I use to calculate commission?
 
Join Date: Feb 2011
Posts: 3
grs is on a distinguished road
Default

One other thing.
How can I set a result to show an answer correct to 2 decimal places?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to calculate the MAE and RMSE automatically in excell? Jamal NUMAN Excel 0 11-21-2010 04:31 PM
Calculate formula base of list menu rkeles Excel 4 09-22-2010 12:38 AM
Can't calculate formulas Cpat Excel 2 06-09-2010 02:07 PM
Good commission to be earned for writing some office questions iqnetsys Office 0 02-23-2009 05:22 AM
What formula should I use to calculate commission? How to get cells to calculate time? jrasche2003@yahoo.com Excel 2 02-09-2007 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft