Logical functions are the most popular and useful function in Excel.
They are used to test values in other cells and perform actions dependent upon the result of the test.
This function is used to automate tasks in our spreadsheets.
Logical is located in the Function Library within the Formula tab.
Logic Functions in Excel check the data and return the result «TRUE» if the condition is true, and «FALSE» if not.
The Excel logical functions include the boolean operators and conditional tests.
Examsnet