Breaking News
Home / Tips and Tricks / How to use logical functions in Excel: IF, OCH, OR, XOR, NOT

How to use logical functions in Excel: IF, OCH, OR, XOR, NOT  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.