Logical Functions in Excel Tccicomputercoaching.com

These functions include the Boolean operators and conditional tests.

The functions have been grouped into categories, to help you to find the function you need. Each function name links to a full description of the function, with examples of use.

Excel Logical Functions List

Boolean Operator Functions
AND Tests a number of user-defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, orFALSE otherwise
OR Tests a number of user-defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE, orFALSE otherwise
XOR Returns a logical Exclusive Or of all arguments (New in Excel 2013)
NOT Returns a logical value that is the opposite of a user supplied logical value or expression
(ie. returns FALSE is the supplied argument is TRUE and returns TRUE if the supplied argument is FALSE)
Conditional Functions
IF Tests a user-defined condition and returns one result if the condition is TRUE, and another result if the condition is FALSE
IFERROR Tests if an initial supplied value (or expression) returns an error, and if so, returns a supplied value; Otherwise the function returns the initial value. (New in Excel 2007)
IFNA Tests if an expression returns the #N/A error and if so, returns an alternative specified value; Otherwise the function returns the value of the supplied expression (New in Excel 2013)

 

Functions Returning Constant Values
TRUE Simply returns the logical value TRUE
FALSE Simply returns the logical value FALSE

In Microsoft Excel, when you use the logical functions AND and/or OR inside a SUM+IF statement to test a range for more than one condition, it may not work as expected. A nested IF statement provides this functionality; however, this article discusses a second, easier method that uses the following formulas.

For AND Conditions

This function gives result true only if all conditions are true.

I.e.

Condition 1= True

Condition 2= True

Condition 3=True

Result=True

But if any one condition is false then result is also false.

Condition 1= True

Condition 2= False

Condition 3=True

Result=False

IF (65>50 AND &100==56)

            False

Here,condition 1 is true and condition 2 is false , so, result is false

For OR Conditions

 This function gives result true even if anyone condition is true.

I.e.

Condition 1= True

Condition 2= True

Condition 3=True

Result=True

But if any one condition is false then result is also false.

Condition 1= True

Condition 2= False

Condition 3=True

Result=False

IF (65>50 AND &100==56)

            True

Here,condition 1 is true and condition 2 is false , so, result is True

Not Operator:

This operator gives opposite result.

If condition is true then result is false.

i.e. if (True)

            False

Thus, these logical functions are very useful when   some condition based statements are needed.

If you like this post then please       share and like this post.

You can visit us @ tccicomputercoaching.com

Call us @ 98256 18292.

To Learn More About Basic Computer Course, Computer Course

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s