Logical(Microsoft Excel Functions)

01/25/2023

IF function.Change the result of the formula according to the results of the comparison.

IF function.Change the result of the formula according to the results of the comparison.(Microsoft Excel)

LET Function. Attach any name to the result of a formula.

LET Function. Attach any name to the result of a formula.(Microsoft Excel)

LAMBDA function.Create your own function.

LAMBDA function.Create your own function.(Microsoft Excel)

Helper functions.

MAP Function. Decompose cell range and retrieve individual cells.

MAP function. Decompose cell range and retrieve individual cells.(Microsoft Excel)

REDUCE Function. Performs a cumulative calculation of any formula and obtains a result.

REDUCE Function. Cumulative calculation of a cell range.

SCAN function. Creates a range of cells to perform a cumulative calculation of any formula.

SCAN function. Create a cell range for cumulative calculations.(Microsoft Excel)

MAKEARRAY Function. Create a range of cells and set formulas for individual cells.

MAKEARRAY Function. Create a range of cells and set formulas for individual cells.(Microsoft Excel)

BYROW Function. Split a cell range by rows and tally by row.

BYROW Function. Split a cell range by rows and tally by row.(Microsoft Excel)

BYCOL Function. Split a cell range by columns and tally by column.

BYCOL Function. Split a cell range by columns and tally by column.(Microsoft Excel)

ISOMITTED function. Function to define optional arguments.

ISOMITTED function. Function to define optional arguments.(Microsoft Excel)