Excel’s logical functions are used to perform logical tests, as to reveal whether a statement is true or false
Check if a condition is true or false and based on that return us actual results
Combine multiple conditions together
If
Not
AND
OR
If
4.1) If: Verifies whether a condition is met or not. If the condition is met, it returns true value. If the condition is not met, it returns false value.
Syntax =IF(logical_test, [value_if_true], [value_if_false])
Example
Not
4.2) Not: This function is returns true if the condition is false and returns false if condition is true
Syntax = NOT(logical)
Example
AND
4.3) AND: This function is returns true value if all its arguments are satisfied else returns false value. Check all arguments are true.
Syntax = AND(logical1, [logical2],..)
Example
OR
4.4) OR: This function is returns true value if any argument is satisfied, returns false value if all arguments are not satisfied.
Syntax = OR(logical1, [logical2],..)
Example
