NOT function

excel-not-function

The Excel NOT function returns a reversed boolean value of a given logical or boolean value. NOT converts TRUE to FALSE and vice versa.

HLOOKUP Function

Excel-HLOOKUP-function-tutorial-and-examples

The Excel HLOOKUP function searches for a certain value in a row and returns a value from a different row in the same column.

CHOOSE Function

CHOOSE function examples

The Excel CHOOSE function allows you to select a value from a larger set of options by adding an index of the value you want to retrieve.

GROUPBY Function

groupby excel function

The Excel GROUPBY function allows you to group, aggregate, sort, and filter data based on the specified fields.

IFS Function

IFS Function examples and tutorials

The Excel IFS function performs multiple logical tests and allows you to create shorter, easy-to-read formulas.

SWITCH Function

Excel SWITCH function quick guide

The Excel SWITCH function evaluates an expression against a list of values and returns a result corresponding to the first matching value.

SEQUENCE Function

excel-sequence-function

The Excel SEQUENCE function is part of dynamic array functions. It generates a list of sequential numbers in an array.

TOCOL Function

tocol-function-basic-usage

The TOCOL function flattens an array or range into a single column. By default, it keeps all values and scans left to right.

UNIQUE function

The Excel UNIQUE function extracts unique values from a range and returns a list of unique values in that range or list.

FILTER Function

excel filter function

The Excel FILTER function filters range with given criteria and extracts matching records from an array of filtered values.

IF Function

excel-if-function

The Excel IF function uses a logical test and returns two values, one result for TRUE and another for FALSE.

IFERROR Function

excel-iferror-function

The Excel IFERROR function provides a custom value if the formula contains an error; otherwise, it returns the formula’s normal result.

IFNA Function

excel-ifna-function

The Excel IFNA function returns a user-defined value if a formula results in an #N/A (value not found) error.

TRUE Function

excel-true-function

The Excel TRUE function returns the Boolean value TRUE. The function provides compatibility with other spreadsheet programs.

FALSE Function

how to use the FALSE function in Excel

The Excel FALSE function is a compatibility function and returns with the FALSE output. The FALSE Formula in Excel requires no arguments.

OR Function

Excel-OR-function

The Excel OR Function returns TRUE if at least one logical test is evaluated to TRUE and returns FALSE if all logical tests are FALSE.

AND Function

and-function-Excel

The Excel AND function is one of the logical functions. Learn how to determine if all conditions in a test are TRUE.