Creating and expanding the use of nested IF statements

- Although the if function is often used…in a simple and straightforward manner,…it also can handle more complex situations.…In this worksheet called "Nested If,"…there's a formula in cell I2 using the if function.…Simple, straightforward.…But, this company has decided to also give bonuses…to those who have a job rating of three.…And right now the formula only accommodates…those who have a job rating of four or five.…They get $2,500, all others get zero.…Now, what you wouldn't know necessary is…that the if function actually occurs,…or happens, left to right.…

When this is true, the answer is 2500,…the function is finished.…That's the answer, that's it.…But when this test fails,…imagine the logic jumping behind the second comma.…Now, we can put in another if here.…Now remember, the logic of if says…we don't even go here unless the job rating…is one, two, or three.…If it's a four or a five, we've got our answer already.…So, when we put in an if right here,…we're about to test for the job rating…being one, two, or three.…