Excel Function List - My Excel Academy

Excel Functions

Excel Functions List

Below is a comprehensive list of Excel functions to help you become a master in Microsoft Excel.

Logical

AND	Test multiple conditions with AND	logical1 logical2 ...
BYCOL	Applies a LAMBDA to each column and returns an array	array function
BYROW	Applies a LAMBDA to each row and returns an array	array function
FALSE	Generate the logical value FALSE
IF	Test for a specific condition	logical_test value_if_true value_if_false
IFERROR	Trap and handle errors	value value_if_error
IFNA	Trap and handle #N/A errors	value value_if_na
IFS	Test multiple conditions, return first true	test1 value1 test2, value2 ...
LAMBDA	Creates a function value, to be called within formulas	parameter_or_calculation ...
LET	Assigns calculation results to names	name1 name_value1 calculation_or_name2 name_value2 ...
MAKEARRAY	Returns a calculated array	rows columns function
MAP	Returns an array by mapping each value to a new value	array lambda_or_array2 ...
NOT	Reverse arguments or results	logical
OR	Test multiple conditions with OR	logical1 logical2 ...
REDUCE	Reduces an array to an accumulated value	initial_value array function
SCAN	Scans an array and returns a new array	initial_value array function
SWITCH	Match multiple values & return first match	expression value1 result1 ...
TRUE	Generate the logical value TRUE
XOR	Perform exclusive OR	logical1 logical2 ...