Creating and expanding the use of nested IF statements

There are times when you're using the IF function when you want to provide more …than just two answers. Maybe three, maybe four. …In this worksheet, in column I, is a formula that tests to see if a job rating …is four or five, and when that's true, the answer is 2,000. …Otherwise blank, empty. This company has changed its mind and now …wants to give smaller bonuses to those with a job rating of 3. …Now, when you're looking at a function, you can't really observe what's happening …as it's actually being used, but the logic actually happens left to right.…

When this condition is true In other words, when the J2 entry is 4 or 5, the …answer's 2000, and you could say the logic stops, the function is over. …But when this condition fails, the logic goes after the 2000, and you could say …it's waiting right there. And so what we're about to do now is to …say, let's check and see if the job rating is 3. …And so we're putting in a second if, called a nested IF. …If this job rating equals 3 comma, when that's true, we're going to provide an …