![]() You should never nest that many, but it is nice to know there is no problem nesting 8 or 9. It was an ugly day when the powers that be changed the commission plan and you needed a way to add an eighth IF function. With that version, you cannot nest more than 7 IF functions. If you‘re using Excel 2003, your formula is already nearing the limit. The toughest part of such a formula is remembering how many closing parentheses to put at the end of the formula. These formulas get longer and longer as there are more levels. “If sales are over $500K, then the discount is 20% otherwise.” The third argument of the IF function is a whole new IF function that tests for the second level: "If sales are over $250K, then the discount is 15% otherwise.” You always start at either the high end or the low end of the range. The normal approach is to start building a nested IF formula. The one shown in this tip is pretty tame. ![]() ![]() I became pretty used to commission plans with all sorts of conditions. I was always modeling some new bonus program or commission plan. A long time ago, I worked for the vice president of sales at a company.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |