Question

what do you understand by logical formula how many types of logical operations are available in Excel

Answer 1

The tutorial explains the essence of Excel logical functions AND, OR,  XOR and NOT and provides formula examples that demonstrate their common and inventive uses.

Last week we tapped into the insight of Excel logical operators that are used to compare data in different cells. Today, you will see how to extend the use of logical operators and construct more elaborate logical tests to perform more complex calculations and more powerful data analysis. Excel logical functions such as AND, OR,  XOR and NOT will help you in doing this.