Logical functions are used in Excel to test whether a condition is true or false. Depending on the result of the test, you can then elect to do one thing or another. These decisions can be used to display information, perform different calculations, or to perform further tests.
There are four main logical functions in Excel:
- IF: The IF function is the most basic logical function. It allows you to test a condition and return a different value depending on whether the condition is true or false.
- AND: The AND function returns TRUE if all of its arguments are TRUE.
- OR: The OR function returns TRUE if any of its arguments are TRUE.
- NOT: The NOT function returns the opposite of its argument.
Logical Functions
Learn how to use Logical Functions in Excel, such as IF, AND, OR and NOT.
Logical Functions: If
The IF function checks whether a condition is met, and returns one value if true and another value if false.
1. For example, take a look at the IF function in cell C2 below.
Explanation: if the score is greater than or equal to 60, the IF function returns Pass, else it returns Fail. Visit our page about the IF function for many more examples.
And
The AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false.
1. For example, take a look at the AND function in cell D2 below.
Explanation: the AND function returns TRUE if the first score is greater than or equal to 60 and the second score is greater than or equal to 90, else it returns FALSE.
Logical Functions: Or
The OR function returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false.
1. For example, take a look at the OR function in cell D2 below.
Explanation: the OR function returns TRUE if at least one score is greater than or equal to 60, else it returns FALSE. Visit our page about the OR function for many more examples.
Not
The NOT function changes TRUE to FALSE, and FALSE to TRUE.
1. For example, take a look at the NOT function in cell D2 below.
Explanation: in this example, the NOT function reverses the result of the OR function (see previous example).
Next Chapter: Cell References |