You can use the IF function with text, numbers, or any combination, giving you flexibility. Here, we’ll explain the syntax for the formula and arguments followed by a few examples to help you ...

You can’t use it to split values based on a conditional value in a second column. Instead, we’ll use two IF () functions, one for debit and one for credit.

References Microsoft Support: The IF Function - What It Is, and How to Use It Microsoft Excel 2010: Illustrated Complete; Elizabeth Reding and Lynn Wermers ...

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.

Learn how to use IF & nested IF statement in Google Sheets. & highlight a row using conditional formatting, set up multiple conditional formatting rules.