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.

If you’ve ever written software, you know that if-then statements are the building blocks of any program. That same logic can work on yourself. Using simple if-then or when-then constructs, you can ...