I have a Sliding Scale Commission that I pay my staff. They have to submit an invoice to me to show how much sales have been done and then how much I need to pay them in commission. I would like to create a generic Excel spreadsheet that they complete the total sales amount and ...
Being perverse, I performed the calculation for each band and relied upon convexity of the piecewise-linear sales/commission curve to determine that lowest value is the correct value. The final return values include a check that the 'required' sales indeed returns the target commission. =LET(delt...