A function in Excel is a preset formula, that helps perform mathematical, statistical, and logical operations. Worksheet functions are categorized by their functionality.

Logical Functions

The Excel logical functions include the boolean operators and conditional tests. All the Excel logical functions are listed below. Please click "Example" for geting full description of the function, with examples of use.

Functions Syntax Tutorial
IF Function IF(logical_test, [value_if_true], [value_if_false]) Example
IFS Function IFS(logical_test1, value if true,….) Example
IFERROR Function IFERROR(VALUE,value_if_error) Example
AND Function AND(logical1,logical2) Example
OR Function OR(logical1,logical2) Example
Excel NOT Function NOT(ligical) Example