EXCEL REPLACING NESTED IF STATEMENTS WITH VLOOKUP

摘要

Consider the calculation for a bonus plan with multiple levels. With nested IF statements, you need to start at either the highest end or the lowest end of the bonus table. The formula in Figure 1, for example, starts at the low end of the table. The beginning of the formula (=IF(D2＜5000,0.02,) means, "If this sale is less than $5,000, the bonus is 2%." The final comma leads to the "else" portion of the IF function. The formula after the second comma is what happens once Excel decides the amount is greater than or equal to $5,000.