#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Put .015 in cell D1
Put .0075 in E1 =IF(A1<=25000,A1*$D$1,25000*$D$1+(A1-25000)*$E$1) |
#3
|
|||
|
|||
Thanks for that.
|
#4
|
|||
|
|||
One other thing.
How can I set a result to show an answer correct to 2 decimal places? |
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 |
How to get cells to calculate time? | jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |