How to split a column using an IF() function in Excel

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