E) Logical Function:
The logical function checks the logical operation and returns the result based on logic defined.
1) And()
And function checks whether all arguments are true, and returns TRUE if all arguments are TRUE.
Syntax:- =And(Logical1,Logical2,Logical3,....)
E.g. =And(12<23,12>33,12>=36) Press Enter
Output FALSE
2) Or()
Or function checks whether any of the argument are true, and returns TRUE, or FALSE only if all arguments are false.
Syntax:- =or(Logical1,Logical2,Logical3,....)
E.g. =And(12<23,12>33,12>=36) Press Enter
Output TRUE
3) Not()
Not function changes FALSE to TRUE, or TRUE to FALSE.
Syntax:- =Not(Logical)
E.g. =Not(12<23) Press Enter
Output FALSE
E.g. =Not(12>23) Press Enter
Output TRUE
4) IF()
If function checks whether a condition is met, and return one value if TRUE and another value if FALSE.
Syntax:- =If(Logical Test,"Value_if_true","value_if_false")
E.g. =If(12<23,"Arun","Varun") Press Enter
Output Arun
E.g. =If(12>23,"Arun","Varun") Press Enter
Output Varan
Functions are classified into following categories:-