Written by Retrieves the content of a cell based on its specified row and column indices.
Retrieves an aggregated value from a pivot table based on designated row and column headings.
Calculates the number of columns in a chosen array or range.
Returns a specified item from a list of options based on a given index.
Evaluates an expression against a series of cases and returns the value of the first case that matches, along with an optional default if no cases are met.
Returns true if at least one of the provided arguments is logically true; returns false only if all arguments are logically false.
Assigns a name with the results of the value_expression and returns the outcome of the formula_expression. The formula_expression can reference the names defined within the LET function’s scope. Importantly, the value_expressions are evaluated just once, even if referenced multiple times in subsequent value_expressions or in the formula_expression.
Establishes and returns a custom function using defined names and a formula_expression that incorporates them. You can invoke the resultant function with as many arguments as specified in the names.
Assesses various conditions and returns a corresponding value for the first condition that evaluates to true.
Returns true when every argument supplied is logically true; returns false if any argument supplied is logically false.