I am a portfolio manager and I owe some profit comission my clients. what will be the best soluion to calculate a specific condition (attached file)
Usually when my client earns-
up to 0-25% I claim 15% of their net profit.
up to 25%+ to 50% I claim 20% of their net profit.
up to 50%+ to 80% I claim 25% of their net profit.
and over 80% I claim 30% of their net profit.
So, I need your valuable suggestion and help to solve this.
I always appreciate your support.
Thanking in advance.
rif
Bookmarks