•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Using SUMPRODUCT to calculate progressive charges/taxes/etc.
Hi all, I'm looking to create a tiered fee system within my financial planning practice and I'm struggling to get it to work. I know SUMPRODUCT should do it, but I can't figure out how to do it properly. I am not a power user by any stretch, and I'm struggling to get this to work. What I'm trying to do is set up my charges as follows:
$0-400k - 1%
$400k-1.5m - 0.75%
$1.5m-2.5m - .6%
$2.5m-5m - .5%
$5m-7.5m-.35%
$7.5m+ - .2%
Can anyone give me some guidance on this?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#financial modeling
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#SUMPRODUCT
#tiered fee system
#financial planning
#progressive charges
#taxes
#$0-400k
#$400k-1.5m
#$1.5m-2.5m
#$2.5m-5m
#$5m-7.5m
#$7.5m+
#charges
#guidance
#user