Logical Function

IF | NOT | AND | OR

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

 
 
 

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

1.png

4.2) Not: This function is returns true if the condition is false and returns false if condition is true

Syntax = NOT(logical)  

Example

2.png

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

3.png
 

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

4.png

Want More Basic Excel Deep Dives