Tier Commission Formula

[jlr123]

A new request for a formula:

Revenue: 125,206.00 Commission Amt:_________

Tier Range Commission Rate
0-124,204.99 1.75%
124,205-144,204.99 2.25%
164,205 -184204.99 2.5%
184205-999,999 3.0%

Thanks.

 

[SkipVought]

Hi,

Commission Total: =INDEX(C3:C7,MATCH(C1,A3:A7,1),1)*C1

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[Andrzejek]

It is not very clear of what you need.

Do you need a formula to retrieve a [blue]Commission Rate (C)[/blue] for any Revenue Sold (B) so you can calculate Commission Amt. (D) ?

[pre]
A B C D
Name Revenue Sold [blue]Commission Rate[/blue] Commission Amt.
Susie $125,206.00 [blue]2.25%[/blue] =B2 * C2
Bob $100,000.00 [blue]1.75%[/blue] =B3 * C3
Jack $985,000.00 [blue]3.00%[/blue] =B4 * C4
[/pre]
Or you do not care to display Commission Rate, you just need a formula to calculate Revenue Sold * appropriate Commission Rate and give you the result?

Or, something else...?



---- Andy

There is a great need for a sarcasm font.

 

[SkipVought]

Revenue: 125,206.00 Commission Amt:_________

Given a Revenue Sold, what is the Commission Total?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[jlr123]

Thanks Skip.