Excel logical functions

Here is a new post which will help you to use the logical function in Excel.

logical functions

IF function: This function tests a condition.

• If the condition is met it is considered to be TRUE.
• If the condition is not met it is considered to be FALSE.
• Depending upon the result, one of two actions will be carried out

AND function: This function tests a number of supplied conditions and returns:

• TRUE if ALL of the conditions evaluate to TRUE or
• FALSE otherwise (i.e. if ANY of the conditions evaluate to FALSE)

OR function: This function tests a number of supplied conditions and returns:

TRUE if ANY ONE of the conditions evaluate to TRUE or
FALSE otherwise (i.e. if Both of the conditions evaluate to FALSE)

NOT function: This function tests a number and provides a negation function to give input.

Note: the #VALUE! -  The error occurs if any of the supplied logical_test arguments are text values.