Excel Formula - any help appreciated
Thanks very much guys, I'll now be able to pay some had working sales people!
Chris
--
Chris
"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
|