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.
The complete Excel Functions list includes lookup, logic, date and time, text, information, and math functions with examples. Excel Functions are built-in presets, so Excel functions are hard-coded formulas with short, user-friendly names.
The Excel NOT function returns a reversed boolean value of a given logical or boolean value. NOT converts TRUE to FALSE and vice versa.
The Excel HLOOKUP function searches for a certain value in a row and returns a value from a different row in the same column.
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.
The Excel GROUPBY function allows you to group, aggregate, sort, and filter data based on the specified fields.
The Excel IFS function performs multiple logical tests and allows you to create shorter, easy-to-read formulas.
The Excel SWITCH function evaluates an expression against a list of values and returns a result corresponding to the first matching value.
The Excel SEQUENCE function is part of dynamic array functions. It generates a list of sequential numbers in an array.
The TOCOL function flattens an array or range into a single column. By default, it keeps all values and scans left to right.
The Excel UNIQUE function extracts unique values from a range and returns a list of unique values in that range or list.
The Excel FILTER function filters range with given criteria and extracts matching records from an array of filtered values.
The Excel IF function uses a logical test and returns two values, one result for TRUE and another for FALSE.
The Excel IFERROR function provides a custom value if the formula contains an error; otherwise, it returns the formula’s normal result.
The Excel IFNA function returns a user-defined value if a formula results in an #N/A (value not found) error.
The Excel TRUE function returns the Boolean value TRUE. The function provides compatibility with other spreadsheet programs.
The Excel FALSE function is a compatibility function and returns with the FALSE output. The FALSE Formula in Excel requires no arguments.
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.
The Excel AND function is one of the logical functions. Learn how to determine if all conditions in a test are TRUE.