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?

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