Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

Learn how Excel's LAMBDA function can simplify formulas, create custom functions, and streamline your spreadsheets with ease.

A video demonstration also is available at the bottom of this article. Note that the walk-through and video were made using Microsoft Excel 365 for PCs. Other versions of Excel may work differently.