There are 7 logical functions varying in usefulness, power and potential complexity.

Function Usefulness Power Complexity
AND
FALSE
IF
IFERROR
NOT
OR
TRUE

Boolean Operator Functions

Function Usefulness Power Complexity
AND
NOT
OR

Conditional Functions

Function Usefulness Power Complexity
IF
IFERROR

Constant Value Functions

Function Usefulness Power Complexity
FALSE
TRUE
#1)
Using a Logical function:
Using a Logical Excel function

Summary

Logical functions can range from very simple to very complex depending on how you need to use them. They are primarily used to state or evaluate conditions as part of decision making from data.