From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Expanding nested IF statements

Expanding nested IF statements

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Expanding nested IF statements

“

- In this worksheet, called "Nested IF," there are formulas in Column I providing bonuses but only for those who have a job rating of four or five. If you'd like to expand this function, though, and also include bonuses for those who have a job rating of three, you could proceed in a number of different ways. If there's no kind of numerical comparison, or relationship between the values that we're using, we'll have to use the IF Function. Otherwise, possibly, we could use some different kinds of formulas to come up with an answer here. This company has changed its mind and says the following: "We still want to give bonuses to people "who have a job rating of four or five, "and that's going to be $3,000. "But these other people here who have a job rating "of three, they deserve a bonus, although a smaller one." So, the logic of the IF Function actually happens from left to right. When this test fails, the logic jumps behind that second comma. So let's imagine that we're viewing this in…

Contents