| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I combine multiple IF statements to come up with 1 value?
I am trying to create an automated commission calculation sheet for my sales
team, however I can't find how to create the formula. What I'd like to achieve is the following: revenue: 0 - 10 == no commission 10.1 - 20 == 2.5% commission of the amount over and above 10 20.1 - 30 == 5% commission of the amount over and above 20 etc. The formula I created now double counts the amount of revenue and that is not the intention. Thank you for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Intersect Range in If statements | Excel Discussion (Misc queries) | |||
| Multiple if statements with multiple conditions | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| multiple if statements | Excel Worksheet Functions | |||
Threaded Mode
