Logical(Microsoft Excel Functions)

01/25/2023

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

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

LAMBDA function.Create your own function.

Helper functions.

MAP Function. Decompose cell range and retrieve individual cells.

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

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

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

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

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

ISOMITTED function. Function to define optional arguments.