Use functions to find the same parts of two phrases in Excel, don't rely on the naked eye

How to find the same parts from two phrases in excel table using functions? It’s not about eyesight

If you want to explain the function =IF(COUNT(FIND(A$2:A$1016,B2,1)),"EMS",""), I will explain it to you

First of all, the IF function will have two judgments, output the result if it is satisfied (TRUE), and output another result if it is not satisfied (FALSE).

So what’s inside your function? The condition part is COUNT(FIND(A$2:A$1016,B2,1))

When this condition is met, EMS will be output. If not, a null value (that is, "") will be output.

Explanation of condition part:

First explain the FIND function; you have a mistake here. The FIND function should be FIND(B2,$A$2:$A$1016,1), which means that based on the value in B2, search in the fixed cell range A, starting from the first character to find whether there is a value containing the content of B2 . If so, output the character position of B2 in this cell (column A). Returns a numeric value

Then COUNT is to calculate the position of cells containing numbers. (In fact, this step is to know whether the target has been found, because finding the target will output a numerical value, then COUNT will be TRUE, so the value of EMS will be obtained, and vice versa. Got null value.

Who wrote this function for you? It’s not very good.

How to use if function in excel table

1. The IF function determines "TRUE" and "FALSE" based on the specified conditions, thereby returning the corresponding content.

2. Function structure: =if (condition, result that meets the condition, result that does not meet the condition).

3. Usage: Use relational operators (mainly =,,>,=, 4. Steps: Formula-insert function-write logical expression

5. Nested IF function execution process, as shown below:

Example formula: IF(E2>=85, "Excellent", IF(E2>=75, "Good", IF(E2>=60, "Pass", "Fail")))

Explanation: Functions are executed from left to right. First calculate E2>=85. If the expression is established, it will display "Excellent". If it is not established, continue to calculate E2>=75. If the expression is established, it will display "Good". Otherwise, continue to calculate E2>=60. If If the expression is true, "pass" is displayed, otherwise "fail" is displayed. As shown below

The above is the detailed content of Use functions to find the same parts of two phrases in Excel, don't rely on the naked eye. For more information, please follow other related articles on the PHP Chinese website!