| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help with long if then statement
I need to create a if then statement for commissions calculations and it is on a cumulative total of sales. I think the formula is to long and do not know how to shorten it and make it work.
IF(B22500001,(C21*0.1),IF(B22250001,IF(C2250000 1,(((C22-500000)*0.1)+((500000-B22)*0.08)),IF(C22250001,(C21*0.08),IF(B22<250001 ,IF(C22500001,(((C22-500000)*0.1)+20000+(250000-B22)*0.05)),IF(C22250001,(((C22-250000)*0.08)+(250000-B22)*0.05),(C21*0.05))))))) B C line Commissions Jan Feb Expected Annual Sales $400,000 $135,000 21 Month Sales - 344,861 - 22 Total Sales 344,861 Commission earned 20,089 - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement too long, need another way | Excel Worksheet Functions | |||
| very long statement | Excel Discussion (Misc queries) | |||
| IF statement too long | Excel Discussion (Misc queries) | |||
| Long IF Statement | Excel Discussion (Misc queries) | |||
Threaded Mode
