ISOMITTED function. Function to define optional arguments.(Microsoft Excel)
Introduces the use of the ISOMITTED function.
BYCOL Function. Split a cell range by columns and tally by column.(Microsoft Excel)
Includes usage of the BYCOL function and examples of its use.
SCAN function. Create a cell range for cumulative calculations.(Microsoft Excel)
Includes how to use the SCAN function, examples of its use, and how it differs from the REDUCE function.
BYROW Function. Split a cell range by rows and tally by row.(Microsoft Excel)
The BYROW function is a new function added in February 2022.
It is a helper function for the LAMBDA function th ...
LET Function. Attach any name to the result of a formula.(Microsoft Excel)
The LET function is a new function added in September 2020 to make formulas easier to read and improve calculation sp ...
IF function.Change the result of the formula according to the results of the comparison.(Microsoft Excel)
Japanese version.
The IF function is a function that changes the result according to a condition.
Together ...
MAKEARRAY Function. Create a range of cells and set formulas for individual cells.(Microsoft Excel)
The MAKEARRAY function is a new function added to Excel in February 2022.
It is a helper function for the LAMBDA ...
REDUCE Function. Cumulative calculation of a cell range.(Microsoft Excel)
Includes usage of the REDUCE function and examples of its use.
MAP function. Decompose cell range and retrieve individual cells.(Microsoft Excel)
Includes usage of the MAP function and examples of its use.
LAMBDA function.Create your own function.(Microsoft Excel)
Includes usage of the LAMBDA function and examples of its use.