Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

To get detailed information about a function, click its name in the first column.

Function

Description

AND function

Returns TRUE if all of its arguments are TRUE

BYCOL function Office 365 button

Applies a LAMBDA to each column and returns an array of the results

BYROW function Office 365 button

Applies a LAMBDA to each row and returns an array of the results

FALSE function

Returns the logical value FALSE

IF function

Specifies a logical test to perform

IFERROR function

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula

IFNA function Excel 2013

Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression

IFS function Excel 2016

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

LAMBDA function Office 365 button

Create custom, reusable functions and call them by a friendly name

LET function Office 365 button

Assigns names to calculation results

MAKEARRAY function Office 365 button

Returns a calculated array of a specified row and column size, by applying a LAMBDA

MAP function Office 365 button

Returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value

NOT function

Reverses the logic of its argument

OR function

Returns TRUE if any argument is TRUE

REDUCE function Office 365 button

Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator

SCAN function Office 365 button

Scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value

SWITCH function Excel 2016

Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.

TRUE function

Returns the logical value TRUE

XOR function Excel 2013

Returns a logical exclusive OR of all arguments

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

See Also

Excel functions (by category)

Excel functions (alphabetical)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.