Below listed are the various logical functions of Microsoft Excel 2007.
AND function is used to check if all the given conditions are true.
FALSE function takes no argument and returns a logical value of FALSE.
IF function tests a condition and displays the result based on the condition.
OR function tests two or more conditions given and checks if atleast one is true.
NOT function is used to check whether the given condition/test fails or not.
TRUE function takes no argument and returns a logical value of TRUE.