|
|
#1
02-20-2011, 02:51 PM
|
|||
|
|||
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? 
|
|
|
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 |
Windows XP 
Office 2000
Threaded Mode