Logical(Microsoft Excel Functions)
Contents
- 1. IF function.Change the result of the formula according to the results of the comparison.
- 2. LET Function. Attach any name to the result of a formula.
- 3. LAMBDA function.Create your own function.
- 3.1. Helper functions.
- 3.1.1. MAP Function. Decompose cell range and retrieve individual cells.
- 3.1.2. REDUCE Function. Performs a cumulative calculation of any formula and obtains a result.
- 3.1.3. SCAN function. Creates a range of cells to perform a cumulative calculation of any formula.
- 3.1.4. MAKEARRAY Function. Create a range of cells and set formulas for individual cells.
- 3.1.5. BYROW Function. Split a cell range by rows and tally by row.
- 3.1.6. BYCOL Function. Split a cell range by columns and tally by column.
- 3.1.7. ISOMITTED function. Function to define optional arguments.
- 3.1. Helper functions.