Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula - any help appreciated
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
HOW CAN I PROTECT A FORMULA IN EXCEL | Excel Discussion (Misc queries) | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |