Excel Logical Formulas

Functions for performing logical tests, conditions, and comparisons in your Excel formulas.

20 formulas

8 Beginner

3 Intermediate

9 Advanced

IF

=IF(logical_test, value_if_true, [value_if_false])

IFS

=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)

IFERROR

=IFERROR(value, value_if_error)

IFNA

=IFNA(value, value_if_na)

AND

=AND(logical1, [logical2], ...)

OR

=OR(logical1, [logical2], ...)

NOT

=NOT(logical)

XOR

=XOR(logical1, [logical2], ...)

TRUE

FALSE

SWITCH

=SWITCH(expression, value1, result1, [default or value2, result2], ...)

LET

=LET(name1, name_value1, [name2, name_value2], ..., calculation)

LAMBDA

=LAMBDA([parameter1, parameter2, ...], calculation)

MAP

=MAP(array1, [array2], ..., lambda)

REDUCE

=REDUCE([initial_value], array, lambda)

SCAN

=SCAN([initial_value], array, lambda)

BYROW

=BYROW(array, lambda)

BYCOL

=BYCOL(array, lambda)

MAKEARRAY

=MAKEARRAY(rows, cols, lambda)

ISOMITTED

=ISOMITTED(argument)