Hello,
I am trying to create a universal formula to help calculate client fees. I am using a sumproduct formula described here to do this. http://mcgimpsey.com/excel/variablerate.html
My problem lies in that some of the clients have a single pricing level, some have a single tier and some have a three tier pricing.
I have all my variables set up in separate columns and each line is a different client. I have a section that calculates the change in rates needed for the formula as describedFee Calculator using Sum Product.xlsx
If anyone can help,it would be hugely appreciated!
Thanks,
Dani
Bookmarks