Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stepped fee calculation
Here's the situation:
Revenue = $2,800,000 I have the following fee schedule: First $1,000,000 = 0% of Revenue Next $500,000 = 5% of Revenue Next $500,000 = 6% of Revenue Next $500,000 = 7% of Revenue Next $500,000 = 8% of Revenue Over $3,000,000 = 9% of Revenue What formula would I write where it looks at the Revenue and then applies the fee schedule? In this case, the result should be $$114,000. Thanks for taking a look! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |