| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate commissions that are not percentage based?
I am trying to create a formula to calculate my commissions, but my
commissions aren't percentage based. The difference between my bill rate and pay rate is the spread. If my spread is between $20 and $30, for example, I get $500. If the spread is between $30.01 and $40, I get $1000, etc. So, the higher the spread, the higher my commissions are. I have a spread sheet that calculates my spread, but I'd like to track commissions also. Any ideas out there? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Start Dates based on Need-By Date? | Excel Worksheet Functions | |||
| how do I calculate a monthly payment based on a variable rate? | Excel Worksheet Functions | |||
| HOW DO I CALCULATE A RUNNING PERCENTAGE | Excel Discussion (Misc queries) | |||
| Calculation based on a condition | Excel Worksheet Functions | |||
| How do I calculate interest and deduct late fees based on date pa. | New Users to Excel | |||
Threaded Mode
