Logical Functions

Below listed are the various logical functions of Microsoft Excel 2007.

And():

AND function is used to check if all the given conditions are true.

False():

FALSE function takes no argument and returns a logical value of FALSE.

If():

IF function tests a condition and displays the result based on the condition.

Or():

OR function tests two or more conditions given and checks if atleast one is true.

Not():

NOT function is used to check whether the given condition/test fails or not.

True():

TRUE function takes no argument and returns a logical value of TRUE.