What formula should I use to calculate commission?

grs · #1 02-20-2011, 02:51 PM

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?

Kimberly · #2 02-20-2011, 03:42 PM

Put .015 in cell D1
Put .0075 in E1

=IF(A1<=25000,A1*$D$1,25000*$D$1+(A1-25000)*$E$1)

grs · #3 02-20-2011, 03:53 PM

Thanks for that.

grs · #4 02-21-2011, 02:17 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM