Excel Formula - any help appreciated
Right you are. Sorry for the confusion.
Horst
On Nov 8, 8:57 am, "Pete_UK" wrote:
I think you will need to amend the table, as follows:
0 0.05
5000 0.10
15000 0.15
20000
etc.
Hope this helps.
Pete
flyswiftly wrote:
I would create a table that I can use a vlookup on. This would allow
me to modify the bands and percentages easily when they change.
x1 y1
5000 0.05
15000 0.10
20000 0.15
the commision formula becomes =vlookup(sales,$x$1:$y$3,2,true)
Hope this helps,
Horst
On Nov 8, 8:21 am, 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- Hide quoted text -- Show quoted text -
|