Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Commission formula
I have a bit of a quandry with this one. I have a spreadsheet I need to
calculate commissions with. First the salespeople enter in how many sales they get each day which then totals at the bottom. The way it works for most of these sales is if they get between 1-4 sales, they will get $2 for each sale. Above and beyond 4, they get $5 for each sale. I have the forumla setup like this: =IF(B28<4,B28*2,6+(B28-3)*5) where B28 is the total number of units sold. The problem is I have one product where the commissions are on three tiers: 1-5 units= $7 6-10 units= $10 11+ units= $13 How would I calculate this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |