What formula should I use to calculate commission?

		Microsoft Office Forums > Microsoft Excel > Excel
What formula should I use to calculate commission?

02-20-2011, 03:42 PM

Kimberly

Windows 7

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Posts: 517

Put .015 in cell D1
Put .0075 in E1

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:07 PM.