Logical(Microsoft Excel Functions) 01/09/2023 05/19/2023
Japanese version.
It includes functions that return TRUE or FALSE mainly by evaluating logical expressions and functions that change the result by evaluating logical expressions.
Functions
Function that changes its value according to its logical value (the result of a logical expression)
Function Importance Description IF High Varying results depending on conditions. IFS High Specify multiple conditions and get the value corresponding to the first matching condition.
Functions to manipulate logical values (results of logical expressions)
Function Importance Description AND High Conditional judgment of logical product(AND). OR High Conditional judgment of logical or. XOR Low Conditional judgment of exclusive or. NOT Middle Performs a negative conditional judgment and inverts the logic value.
Functions that change the result depending on the value
Function Importance Description IFERROR IFNA High Sets the value if the formula is in error. CHOOSE Middle Displays the corresponding value from 1 to 254. SWICTH High Displays the first result matching the specified value.
LAMBDA functions to create custom functions and their helper functions
Function Importance Description LAMBDA High Create custom functions. MAP Low The range covered by the function is divided by cells to obtain individual results. BYCOL Low The range covered by the function is divided by columns, and the aggregate results are obtained for each column. BYROW Low The function divides the range covered by the function by rows and obtains the aggregate results for each row. MAKEARRAY Low Create an array (cell range) with any number of rows and columns, and set individual cell values with any formulas. ISOMITTED Middle Determines whether custom function arguments are set or omitted. The category is included in "Information Functions". REDUCE Low Performs a cumulative calculation of any formula and obtains the result. SCAN Low Creates a range of cells for the cumulative calculation of any formula.
Other Logical Functions
Function Importance Description LET High Attach any name to the result of a formula.