Sharing of commonly used excel judgment functions

php editor Yuzai brings you an article about commonly used Excel judgment functions. The judgment function in Excel is a very practical function that can help us quickly filter and calculate based on conditions. This article will introduce some commonly used Excel judgment functions, including IF function, AND function, OR function, etc., hoping to provide you with some help and inspiration in Excel table processing. Let's learn about the usage and techniques of these functions!

1. Commonly used excel judgment functions

1. IF function: returns different values ​​according to conditional judgment;

Syntax=IF(conditional judgment, the result is true return value , the result is a false return value)

2. OR function: judge multiple logical conditions;

Syntax=OR(Condition 1=Standard 1, Condition 2=Standard 2,... ....Condition N=Standard N)

3. AND function: Multiple conditions are established at the same time;

Syntax=AND(Condition 1, Condition 2,...Condition N ).

4. IFERROR function: When a formula error occurs, the error value is masked and the specified value is displayed;

Syntax=IFERROR (needs to check whether there are erroneous parameters and the value returned when an error occurs).

2. Search function

1. ROW function: Returns the number of rows in a selected cell;

Syntax = ROW(reference).

2. LOOKUP function: Find a value from a single row or column or from an array;

Syntax=LOOKUP (lookup value, search range, return value range).

3. VLOOKUP function: Given a value, find the corresponding value from another worksheet;

Syntax=VLOOKUP(lookup value, search area, return the data in the search area number of columns, fuzzy match/exact match).

4. INDEX function: In a given range of cells, find the value or reference of the cell at the intersection of a specific row and column. It is often used with the MATCH function;

Syntax=INDEX(cell area, row number, column label).

5. MATCH function: Find the position of the specified value in the specified array area;

Syntax=MATCH (search value, search range, sort order).

6. INDIRECT function: Reference the specified value;

Syntax=INDIRECT (text string, judgment).

7. OFFSET function: Returns the specified reference from the specified base position by the row, column, and column values;

Syntax=OFFSET(base position, offset downward or upward by the number of rows, to the right or Number of columns left offset, height of the referenced area, width of the referenced area).

8. COLUMN function: returns the number of columns;

Syntax=COLUMN(reference).

Data processing is the main function of Excel. It mainly helps us classify scattered data and summarize the rules. For example, students use Excel to perform statistical classification of experimental data and Teachers often use Excel to review students' scores and analyze passing rates, not to mention office workers, who often use Excel to report work. Therefore, the editor hopes that everyone can take the time to understand this tool.

The above is the detailed content of Sharing of commonly used excel judgment functions. For more information, please follow other related articles on the PHP Chinese website!