Excel Formulas

Showing page 17 of 21
AND
Logical

Returns TRUE if all arguments are TRUE

OR
Logical

Returns TRUE if any argument is TRUE

NOT
Logical

Reverses the logic of its argument

TRUE
Logical

Returns the logical value TRUE

FALSE
Logical

Returns the logical value FALSE

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

XOR
Logical

Returns a logical exclusive OR of all arguments

ISBLANK
Information

Returns TRUE if the value is blank

ISERR
Information

Returns TRUE if the value is any error value except #N/A

ISERROR
Information

Returns TRUE if the value is any error value

ISEVEN
Information

Returns TRUE if the number is even

ISFORMULA
Information

Returns TRUE if there is a reference to a cell that contains a formula

ISLOGICAL
Information

Returns TRUE if the value is a logical value

ISNA
Information

Returns TRUE if the value is the #N/A error value

ISNONTEXT
Information

Returns TRUE if the value is not text

ISNUMBER
Information

Returns TRUE if the value is a number

ISODD
Information

Returns TRUE if the number is odd

Page 17 of 21