This is the usefulness of some of the logical functions of Excel

Many are the Excel functions and formulas that Microsoft makes available to us when using the spreadsheet program. These are aimed at all kinds of uses and utilities, so in these lines, we are going to talk about some of the most used in the logical functions section.

Initially, these functions, which we refer to here, can be helpful in automating certain tasks in our spreadsheets. That is why the somewhat advanced users of the program already know them well, but the newer ones, not so much. However, to take advantage of them, you need to have some prior knowledge of the office program.

This is logical IF function in Excel
We are going to start this section with the logical IF function, which could be considered as the most important of all that we will see. It is precisely for this reason that it is the one that perhaps we must first understand. To start we will tell you that this is a formula that accepts a total of three parameters: “= IF (logical_test, [value_if_true], [value_if_false]).

The first of these is the condition for the function to be checked, the second is the action to take if the condition is met, while the last is the action to take if it is not met or is false. The operators to use here are “=”, “<”, “>” ”<=”, “> =”, “<>”.

For example, in case we want to check if a cell contains a number greater than or equal to 100, the formula would be: = IF (B10> = 100, "True", "False").

AND and OR logic function
The AND and OR functions are used when you want to make more than one comparison in the formula since the IF function alone can only handle one condition. Say that these two functions alone will return the value of True or False. Thus AND returns True only if all conditions are met, otherwise it returns False. On the other hand OR returns True if one or all of the conditions are met, and returns False only if all of the conditions are not met.

To see an AND example, we can check if a customer spends at least 1,000 euros and has also been a customer for at least 2 years. The formula would be: = AND (B2> = 1000, C2> = 2). Similarly, if we transfer this to the OR function, we now check whether that customer spends at least 2,000 euros or has been a customer for at least two years: = O (B2> = 3000, C2> = 3). Say that this formula returns True or False.

The XOR logic function
We also find a unique OR function, XOR, which uses the structure of the OR function. This would be = XOR (logica1, [logica2]…), for when only two conditions are evaluated. Thus the function returns True if either condition is true, and False if both are true or neither is true. The difference with OR is that it would return True if both conditions were true.

photo


Excel logical NOT function
And we are going to end with NOT, which is possibly the easiest to understand. And it is that NOT actually inverts the value of its argument. So if the logical value returned is true, it returns FALSE, and vice versa. Its structure is: = NOT (logic). So we can see how it works, let's take an example.

In this example, let's imagine that we are in Spain and we have friends spread all over the world. So we want to show the word "Yes" if where they are now is anywhere but Spain, and "No" if it is Spain. Therefore the function would be: = IF (NOT (B2 = »Spain»), »Yes», ​​»No»).