Thread: how do I figure multiple commission percentages
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default 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..
Reply With QuoteReply With Quote