| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I set up multiple if statements in Excel?
I'm trying to set up a formula to calculate commissions based on weekly
sales, as follows: If $1000<sales<$2500, commission = sales*30% If $2500<sales<$4000, commission = sales*35% If $4000<sales<$4500, commission = sales*40% Can anyone help, please? I'm using Excel 2000. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| lookup multiple occurrences of a value excel | Excel Worksheet Functions | |||
| opening multiple instances of excel | Excel Discussion (Misc queries) | |||
| Excel should allow multiple hyperlinks in a single cell | Excel Discussion (Misc queries) | |||
| Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions | |||
Threaded Mode
