Always enclose text in double quotation marks. The FILTER function in Excel allows you to filter a range of data based on criteria you define. IF Function in Excel IF function in Excel checks whether a condition is met and if its TRUE it returns a value and another value if the condition does not meets FALSE.
Click the Insert Function button on the Formulas tab to display the Insert Function dialog box.
1 Count and Sum. IF function gives excel formula a decision- making capabilities. To write the function go to the VB Editor and begin with the word Function. A custom function must start with a Function statement and end with an End Function statement.