Forum Discussion
Pal26
Apr 16, 2025Copper Contributor
Sliding scale Commission calculation
Hello , I am trying to create a formula in Excel to calculate interpolated commission rates based on a given loss ratio using a predefined table of loss ratios and corresponding commission rates. H...
HansVogelaar
Apr 16, 2025MVP
In F3:
=48.75%-F1/4
Final commission:
=F2*F3
- Pal26Apr 17, 2025Copper Contributor
Thank you for the above reply . I need to use this on multiple worksheets so I need a dynamic formula .