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.
Here is an example of false logic
● In the “Free” column we display the logical values TRUE or FALSE according to the following condition: is the phone number code equal to “8800”? We introduce the formula in cell C3. ● LEFT(B3;4)=”8800”-condition for checking the equality of the first four characters of the string to the string to the specified value (“8800”).If the condition is met, the TRUE () function will return a true logical value. ●If the condition is not fulfilled, the FALSE() function will return a false logical value.
● C3=TRUE()-checking the condition “is the value stored in cell C3 ●Equal to the value returned by the function(logical truth)?” ● 0-call cost, if the condition is met. ● D*1.5 -the cost of the call, if the condition is not met.