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.

Excel is everywhere—more than 750 million people open a workbook each year to balance budgets, fine-tune supply chains, and model billion-dollar deals. Employer ...