ExcelBanter - Formula to calculate commission based on sliding scale

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to calculate commission based on sliding scale (https://www.excelbanter.com/excel-discussion-misc-queries/448500-formula-calculate-commission-based-sliding-scale.html)

Excel Dumbo

Formula to calculate commission based on sliding scale

1 Attachment(s)

Hello,

Please refer attached file

I would like to get a formula to calculate commission based on a sliding scale table shown in the file.

Any help will be greatly appreciated.

Regards,
Dumbo

shanermuls

1 Attachment(s)

Quote:

Originally Posted by Excel Dumbo (Post 1610725)

Hello,

Please refer attached file

I would like to get a formula to calculate commission based on a sliding scale table shown in the file.

Any help will be greatly appreciated.

Regards,
Dumbo

Attached - a few adjustments necessary to table of rewards

Excel Dumbo

Thanks a lot Shaneer Muls...It worked well

All times are GMT +1. The time now is 10:13 AM.