If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

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.

If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead. This allows you to test multiple conditions in order, picking the first that returns true.

How to Use the Countif & Countifs Functions in Excel. ... The COUNTIFS function will search through cell locations in multiple ranges and return a count of "1" for every time all the ranges meet ...