| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Correct way to =IF(B6<7000,B6*0.45)=IF(B6<97000,B6*0.5) ...etc
I am trying to create a formula that will calculate commissions depending on
bechmarks. Example: IF <7000 then multiply by 45% IF 7000, but <9000 then multiply by 50% IF 9000, but <13000 then multiply by 55% The final part of the formula should be as follows: If 13000, but <16000 then multiply by 60%, IF 16000, 100% of the amount 16000 is multiplyed by 100% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
| If correct, add 1 | Excel Worksheet Functions | |||
| Vlookup, What is correct formula for problem below? | Excel Worksheet Functions | |||
| How can I turn auto correct on or off for one column only? | Excel Worksheet Functions | |||
Threaded Mode
