Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for sliding scale calculations
I'm stumped (and embarrased). I can't figure out how to insert a fee formula
that will take a total project value and charge a percentage based on a sliding schedule: Project Value: $250,000 Rate Fee Fee Schedule: First $50,000 5% _____ $50,001 - $200,000 4% _____ $200,001+ 3% _____ TOTAL FEE: $0.00 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for sliding scale calculations
To calculate total fee:
=MIN(A1,50000)*5%+MIN(MAX(IF(A1200000,200000,A1)-50000,0),200000)*4%+MAX(A1-200000,0)*3% If you want the individual parts, simply break the formula down into its 3 sections. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lyn" wrote: I'm stumped (and embarrased). I can't figure out how to insert a fee formula that will take a total project value and charge a percentage based on a sliding schedule: Project Value: $250,000 Rate Fee Fee Schedule: First $50,000 5% _____ $50,001 - $200,000 4% _____ $200,001+ 3% _____ TOTAL FEE: $0.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A formula for sliding scale percentage?????? | New Users to Excel | |||
Sliding scale Question | Excel Worksheet Functions | |||
Calculating a sliding scale | Excel Worksheet Functions | |||
Sliding Scale Percentage via IF? | New Users to Excel | |||
Percentage Commission on a sliding scale. | Excel Discussion (Misc queries) |