Nested functions
Take a deep breath and don’t panic! I just want to show you that if you need to, you can
include one function inside another.
In the example above, we first worked out the Average mark, and then the Pass/Fail outcome.
But we could have done it all in a single step,by using the following formula in row 3:
=IF(AVERAGE(B3:E3) < 50, “FAIL”, “PASS”) In this IF statement, I’ve nestedone function inside another. The reference to cell F4 has
been replaced with a function that calculates the average tutorial mark, and then checks it
against the same condition as before (“< 50”), withthe same possible outcomes. Doing it this
way, you wouldn’t need column F in the worksheet at all.
Take a deep breath and don’t panic! I just want to show you that if you need to, you can
include one function inside another.
In the example above, we first worked out the Average mark, and then the Pass/Fail outcome.
But we could have done it all in a single step,by using the following formula in row 3:
=IF(AVERAGE(B3:E3) < 50, “FAIL”, “PASS”) In this IF statement, I’ve nestedone function inside another. The reference to cell F4 has
been replaced with a function that calculates the average tutorial mark, and then checks it
against the same condition as before (“< 50”), withthe same possible outcomes. Doing it this
way, you wouldn’t need column F in the worksheet at all.
No comments:
Post a Comment