Logical functions are some of the most popular and useful in Excel. They can test values in other cells and perform actions that depend on the results of the test. This helps us automate tasks in our worksheets.
How to use the IF function
The IF function is the most important logical function in Excel and is therefore the first to understand.
Let's look at the structure of the IF function and see some examples of the use. The IF function accepts 3 bits of information:
= IF [value_if_true][value_if_false])
- logical_test: This is the condition of the function to control.
- value_if_true: The action to perform if the condition is met or is true
- value_if_false: The action to perform if the condition is not met or is false.
Comparison operators to use with logical functions
When performing the logical test with cell values, you must be familiar with the comparison operators. You can see a summary of these in the table below.
Now let's look at some examples of it in action.
About Function Example 1: Text Values
In this example, we want to test if a cell is equal to a specific phrase. The IF function is not case-sensitive, so it does not take into account upper and lower case letters.
Read the remaining 66 paragraphs