XOR function.Conditional judgment of exclusive OR.(Microsoft Excel)
Japanese version.
A companion to the AND and OR functions, it retrieves the exclusive OR.
XOR is TRUE onl ...
AND Specify logical OR and logical AND for the judgment condition.(Microsoft Excel)
Japanese version.
This function is used to specify logical OR and logical AND for IF function, IFS function, co ...
IFS function.Specify multiple conditions and get the value corresponding to the first matching condition.(Microsoft Excel)
Japanese version.
Specify multiple conditions and get the value corresponding to the first matching condition.
SWICTH function.Displays the first result matching the specified value.(Microsoft Excel)
Japanese version.
Displays the first result matching the specified value.
How it works=SWITCH(expression, va ...CHOOSE function. Displays the corresponding value from 1 to 254.(Microsoft Excel)
Japanese version.
Displays the corresponding value from 1 to 254
How it works=CHOOSE(Index_num,Value1 to Val ...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)
Japanese version.
The LET function is a new function added in September 2020 to make formulas easier to read an ...