IF Function 101
Using “if” ultimatums with your toddler accomplishes nothing.
Using the IF function in Excel accomplishes many things, most importantly, adding a healthy dose of data-based logic to your decisions. Enter data to represent multiple possible scenarios, and then use the IF function to compare projected outcomes.
For example, if you’re trying to select a vendor from a huge list of options, you might use an IF function (=IF(CELL>1000, “overbudget”) to quickly make your first round of budgetary eliminations.
Using IF functions can be a little intimidating, especially the first time you do it and most especially if things don’t work exactly the way you thought they would.
Wouldn’t it be nice if you had a close friend or colleague nearby to explain the ins and outs?
The videos and articles below get you as close to that dream scenario as possible:
Watch How to Use the Excel IF Function on YouTube to learn how to run a basic IF scenario.
Watch Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions) on Youtube to learn how to construct detailed functions and even combine them with other functions.
Watch Nested IF function on Microsoft’s Support page to learn how to run IF functions within IF functions.
Watch IF Function in Excel Tutorial on Youtube to run through a series of logical comparisons.
Watch 15 IF Statement Examples in Excel on Youtube to learn how to use many different IF statements for a variety of purposes.
Want more detail or some tips that are a little more readable? We got you.