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.

Along the way, you’ll learn several different ways to enter formulas and functions in Excel. We’ll demonstrate using Excel for Windows under a Microsoft 365 subscription.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

Open an Excel worksheet and add data to two columns, where the first column has one number and the second has four different ones. For example, type "18" in cell "A1" and "30", "13", "80" and "7 ...