Excel Formulas
Showing page 17 of 21
IFERROR
Logical
Returns a value you specify if a formula evaluates to an error; otherwise returns the formula's result
IFNA
Logical
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
IFS
Logical
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
SWITCH
Logical
Evaluates an expression against a list of values and returns the result corresponding to the first matching value
ISFORMULA
Information
Returns TRUE if there is a reference to a cell that contains a formula