ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I figure multiple commission percentages (https://www.excelbanter.com/excel-worksheet-functions/138387-how-do-i-figure-multiple-commission-percentages.html)

Scott L

how do I figure multiple commission percentages
 
What type of formula can I use to calculate a percentage range?
I want to figure a certain percentage range for a commission.

80% - 89% = 1.25% paid out
90% - 99% = 1.50% paid out

Etc..

JE McGimpsey

how do I figure multiple commission percentages
 
One way:

http://www.mcgimpsey.com/excel/variablerate.html

In article ,
Scott L <Scott wrote:

What type of formula can I use to calculate a percentage range?
I want to figure a certain percentage range for a commission.

80% - 89% = 1.25% paid out
90% - 99% = 1.50% paid out

Etc..



All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com