1, the sum function, that is, the sum function, is mainly used to calculate the sum of two or more values, or the sum of a cell area. It is most commonly used for summation calculation of cell areas, but it is also often used for complex combinatorial functions, such as combinatorial applications with functions such as offset and small.

2. The if function, also known as the judgment function, is used to judge whether a condition is true, and if it is true, it returns a value, otherwise it returns another value.

3.lookup function is used to find the value of a row or column and return the corresponding value of another row or column. Simply put, it is query matching, such as querying the position of a text in column A, and then matching its corresponding position in column B. ..

4. The 4.vlookup function, which is also a query matching function, has a similar function to lookup, but at first glance, this function is simpler than lookup function and the expression is clear.

5. The function of the 5.match function is simply to return the position of the search value in the cell area, and the result is expressed in numbers, such as querying the position of Zhang San in the name column. If ranked third, the result is 3. So it is also common in some combination functions, such as the combination with vlookup and offset functions.

6.choose function can be said to be a retrieval function, in which the number of digits returned refers to which value is returned.