Excel is for the Birds! Nested IF Formulas


Use a GPS lately?  Common as it is, it's actually a technological miracle made possible by tons and tons of IF statements.  "If he turns off the route, recalculate..."  "If she slows down, reassess the arrival time..." And on and on!

Somewhat similar is Excel's ability to handle what are called nested IF statements.

Let's say we had three letters of the alphabet--A, B, and C--and we needed to determine the extent to which they were in order.  One in order?  Two?  All three?

In English, we might say it like this:

"If A is in the first position, then look at the second position.  If B is in the second position, then look in the third position.  If C is in the third position, then return the phrase 'IN ORDER.'"

If any of these conditions fail along the way, we can return a text string accordingly.

So here we go!  First we have our strings.

We use a MID formula to break out the first, second, and third character.

Then we use our nested IF formulas, one inside of the other.  Rather than "nesting," some prefer to see them as links in a chain or branches of a decision tree.  Whatever works for you!

Need additional help with IF, nested IFs, MID, or other Excel elements?  Reach out today via live chat, email, or phone and we'll get you fixed up in minutes!