Tags: Excel Commission and Bonus Formulas Md. Abdur Rahim Rasel MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His...
In this post I will explain how to calculate a dollar or percentage commission payout in one cell using the SUMPRODUCT function. Calculating commissions on a tiered rate structure can be difficult because you are trying to determine the cumulative payout based on different rates at each tier, a...
The formula is=IF(F2>20000,0.02,IF(F2>15000,0.0125,IF(F2>10000,0.01,IF(F2>7500,0.0025,IF(F2>1000,0.001,0)))*F2. As the commission plan becomes more complex, you would have to keep adding moreIFstatements. The current limit is 32IFstatements nested together. As recently as Excel 2003...