Commission Tiers

**scottma** · 01-30-2012, 09:06 PM

I need to calculate a percentage payout. The percentage is based on tiers. example:
100.00 - 200.00 pays 5%
201.00- 300.00 pays 7%

What formula could I use where I would enter230.00 in a cell and it would figure out what tier it fell in and calculate the proper payout? In this case 7% of 230.00.

Thank you in advance for your help

**rylo** · 01-30-2012, 09:23 PM

Hi

In the range D2:E4 enter the values
0,0
101,.05
201,.07

Enter 230 in A1, and in B1 enter the formula

Please Login or Register  to view this content.

HTH

rylo

**scottma** · 01-30-2012, 09:55 PM

That is very cool. Where can I learn more about how to use Vlookup.Can you explain the formula? (A1,D2:E4,2)

**bebo021999** · 01-30-2012, 10:36 PM

Another way.
If your criteria in format like this: "100.00-200.00" in 1 cell A1. 2nd criteria in A2. D1 contains 230.

Please Login or Register  to view this content.

**rylo** · 01-30-2012, 11:23 PM

Hi

Have a look at the help file on VLOOKUP for starters. Another good thing to do is have a look at the vlookup examples on this site and see how they are used.

rylo