Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.

For many of us, before we’ve even finished thinking through a problem, we’ve already started writing IFs. Nested Excel IF statements work; they’re familiar, and they’ve been part of Excel for as long ...