Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF Stmt. to calculate cumulative commissions
Folks,
I am trying to write an IF statement that will do the following: It calculates a commission amount based on 3 level of Sales: If Sales is < = $1,500, calculate 0.0025*1500 If Sales is < = $3,000, calculate 0.0045*3000 If Sales is $3,000, calculate 0.0050* cell reference... Now, this may look easy enough..here's the trick that needs to happen Say, sales is $5,500..the commission calculated should be cumulative i.e. 0.0025 * 1500, + .0045*3,000 + .0050*(remainder amount) What would be a clean way of doing this? I will appreciate any help. Thanks. Regards, Shams. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional IF Statements - cumulative calc. | Excel Worksheet Functions | |||
help with sumif to calculate column | Excel Discussion (Misc queries) | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Calculate commissions | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |