You’ve probably gotten to the point that you have more than 2 outputs when you want to choose. We want to examine the various conditions (one or more than one condition) and how to get some outputs. The article train how to use nested if function. For this, we use Nested_If. In fact, it’s not a specific function, just the type of use of the Excel IF function is important to determine which IF arguments. In this way, we can compare several states and have an output for each mode.
A practical situation
For example, suppose we want to decide on a student’s average:
If the score is above 12 —> Accept
If the score is between 10 and 12 —> conditional and
If it’s under 10 —> it’s false.
In order to solve this problem, we must define in our mind the perfect boundary for our condition. For example, I want to try to separate the passages with a formula. That’s mean:
Tip: A1 represent cell A1 in Microsoft Excel. You should write formula in the next cell.
So far, we could separate those who are bigger than 12 or equal to 12. Now what under the 12 are conditional or false. So, instead of the Value_If_False function or the third argument, write another IF in this way:
It begins from internal function. Because 8 is smaller than 10, then the internal IF output will be false. Now we have an IF that its Value_If_True is Accept and its Value_If_False is false. So Excel compares 8 to 12, and since it is less than 12, the final output of the formula will be rejected.
Tip: In the 2007 version and beyond, the limit of the number of intersecting IFs is 64.
Well, with a simple example you learned How to use nested if function. But keep in mind that too much use of IFs might not be right. It’s hard to debug the formula. Basically, when you think about your IFs on a lot, you’re pretty sure that you can find better solutions in most cases.