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

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.