Hi Folks,
I am not having any luck trying to figure this out, so I figured I would ask here, as you are all the smartest people I know.....
The attached pic is a sales tracker/commission calculator I am working on. Here is the scenario.
If a sale is completed at or above the target margin rate, then the formula I need to calculate is:
Base Commission Rate X Secured Volume X Secured Margin Rate Kicker
However, if the margin rate is below the target, the calculation must be:
Base Commission Rate X Secure Volume
I have not been able to figure this out after a few days of trying. Can anyone help me please?
Thank you.
Joe
Bookmarks