How To Use Logical Functions In Excel

How to use logical functions

Excel’s Logical Functions are a powerful tool. The use of logical functions in Excel, such as AND, OR, XOR, and NOT, will aid you in your task.

And, OR, XOR, and NOT are explained in detail in this article. Formula examples are provided to illustrate how these logical functions may be used in both common and innovative scenarios.

Overview :

In order to interact with the logical values, Microsoft Excel includes four logical functions. AND, OR, XOR, and NOT are the various functions. When you wish to do more than one comparison in your calculation or test numerous conditions instead of just one, you should utilise these functions. In addition to logical operators, when their inputs are evaluated, Excel logical functions return either TRUE or FALSE.

Use of IF Function

Whether A condition is fulfilled, the If function checks to see if it has been met and returns one value if it has and another value if it has not.

IF Function

Final Output:

If the score is more than or equal to 60, the IF function returns Pass; otherwise, the IF function returns Fail. Many more examples may be found on our website dedicated to the IF function.

Use of AND Function

In the case of a true condition, the AND Function returns TRUE; in the case of a false condition, the AND Function returns FALSE.

AND Functions

Final Output:

Explanation: The AND function returns TRUE if the first score is greater than or equal to 60 and the second score is greater than or equal to 90; otherwise, it returns FALSE if neither score is larger than or equal to 60 and neither score is higher than or equal to 90.

Use of OR Function

OR is a function that returns TRUE if any of the conditions are met, and it returns FALSE if all of the conditions are not met.

OR Function

Final Output:

the OR function returns TRUE if at least one score is greater than or equal to 60, else it returns FALSE. Visit our page about the OR function for many more examples.

Use of NOT Function

The NOT function transforms TRUE to FALSE, and FALSE to TRUE.

NOT Function

Final Output:

The NOT function inverts the OR function’s outcome in this example.

Conclusion:

Excel’s logical functions may be used in this manner. Of fact, this is just a smattering of what can be done using AND, OR, XOR, and NOT. Now that you’ve mastered the fundamentals, you’re ready to move on to more complex problems and write clever formulae for your worksheets.

Abhijit

Abhijit currently working with India's No. 1 Ecommerce Company Flipkart. He having 6 years experience in Excel and he is also expertise in various Advance Excel formulas. He awarded by his organization for his outstanding contribution in Analytical Project.

Leave a Reply