Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sales V commission
I need to know how to calculate the following sales commissions as shown below: Sales Payment per order 1-10 £10 11-20 £15 21-30 £20 31-40 £25 How can I create a formula so that whenever I say, sales for Mr "A" are 36 then it shows the result in a cell. Hope someone can help me and thanks. Martin -- Carauto ------------------------------------------------------------------------ Carauto's Profile: http://www.excelforum.com/member.php...o&userid=29500 View this thread: http://www.excelforum.com/showthread...hreadid=492032 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sales V commission
On Thu, 8 Dec 2005 16:58:10 -0600, Carauto
wrote: I need to know how to calculate the following sales commissions as shown below: Sales Payment per order 1-10 £10 11-20 £15 21-30 £20 31-40 £25 How can I create a formula so that whenever I say, sales for Mr "A" are 36 then it shows the result in a cell. Hope someone can help me and thanks. Martin This is exactly what Vlookup is for. Particularly if unlike in this example the relationship between sales and payments are not directly proportional. Create a table in A1:B5 0 0 1 10 11 15 21 20 31 25 Then with 36 in say A8, enter in B8 =VLOOKUP(A8,A1:B5,2) HTH Richard Buttrey __ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
Commission Calculation | Excel Worksheet Functions | |||
Sales Commission calculations | Excel Worksheet Functions | |||
Looking for a temlate for sales and commission input? | Excel Discussion (Misc queries) | |||
sales commission template | Excel Discussion (Misc queries) |