Array formulas might be the most advanced of the formula techniques and while we can’t hope to cover the topic of array formulas in this article, it is important to mention that combining the IF() function with array formulas is a powerful tool. In Excel versions prior to 2007, the formula AVERAGEIF() did not exist.

*Excel Formula Training Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges.*Nov 28, 2019 · To enter your IF Function Arguments, Click the spreadsheet cell where you wish to use the Excel formula. From the Formulas tab, click Insert function… In the Insert Function dialog text box, type “if“. Make sure your cursor is in the Logical_test text box. Click the spreadsheet cell you wish to evaluate. Excel If Else. MS Excel IF ELSE is logical function in which performs logical test. We check multiple conditions with IF ELSE in a single formula which is also known as NESTED IF ELSE.