| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multifunction for one cell
I need to calculate based on "if "scenarios for the purpose of commission
calculations. i.e. if b3 (commission to be split) = 0-$5000. then c3 =b3*50%, if b3 =5001-10001, then c3 = b3*55% and so on. Is this too much to ask? How many "if's" can I place to one cell? Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
