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.

If you’d like to learn about XLOOKUP (), read How to use the newish XLOOKUP () dynamic array function in Excel. I’m using Microsoft 365 on a Windows 10 64-bit system.

Learn how to apply AutoFill to Data Series in Microsoft Excel. AutoFill fills cells with data that follows a sequence or is based on data in other cells.

Learn how to use Excel's What-If Analysis tools, including Goal Seek and Scenario Manager, to explore different scenarios and outcomes using ...