Create a table with your bandings. The revenue in one column and the
%commission in next column, Example given below...

Enter these figures starting with 0 in the Cell A1

0 5%
5000 10%
10000 15%
15000 20%
20000 25%
25000 30%

Enter the Total Revenue in the cell B10 ... Example $15000

To calculate your % commission based on the revenue earned ($15000)

Enter this formula in the cell C10 ...

=VLOOKUP(B10,A1:B6,2)

What we have done here is we have defined a table which can be modified
later based on your requirement, and then we have used the vlookup formula...
The syntax for the vlookup formula is...
VLOOKUP (lookup_value,table_array,col_index_num,range_look up)
lookup_value - is the cell where we have entered the revenue
table_array - the revenue & commission bandings table
col_index_num - the column no. in the array where the commission % is
defined, in our case column 2... so the value here will be 2

Let me know if this helps
--
Krishna Viswanathan


"Chris" wrote:

Hello,

I'm using Excel to calculate commission payments for staff, they are paid a
% of revenue earned based on bandings achieved. For example:

5% of the first £5000
10% from £5001 - £15000
15% from £15001 - £20000
etc

If I have a total revenue figure, how can I write a furmula which calculated
the actual £commission earned based on the sliding scale above?

Any help appreciated,
--
Chris