Frequently Asked Questions
5. Logical Functions in Excel
Last Updated 6 years ago
IF
The IF function checks whether a condition is met, and returns one value if true and another value if false.
AND
The AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false.
OR
The OR function returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false.
NOT
The NOT function changes TRUE to FALSE, and FALSE to TRUE.
The IF function checks whether a condition is met, and returns one value if true and another value if false.
AND
The AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false.
OR
The OR function returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false.
NOT
The NOT function changes TRUE to FALSE, and FALSE to TRUE.