Commonly used formulas of computer quadratic excel

Commonly used formulas for computer secondary excel:

1.SUM: summation formula (the sum function sums the specified parameters. )

2.AVERAGE: average function (returns the average)

3.COUNT: number function (count the number of data in a given data set or cell area. )

4.MAX: Maximize function (returns the maximum value in a set of values. )

5.MIN: Find the minimum value function (returns the minimum value in a set of values. )

7.IF: logical judgment function (is one of the most commonly used functions in Excel, which can logically compare the value with the expected value. )

8.COUNTIF: Single condition number function (is a statistical function used to count the number of cells that meet a certain condition.

)

9.COUNTIFS: Multi-condition number function (apply conditions to cells that span multiple regions, and then count the number of times all conditions are met. )

10.SUMIF: single-condition summation function (sum multiple cells, ranges or references according to specified conditions. )

1 1.SUMIFS: multi-condition summation function (use this function to sum multi-condition cells quickly).

12.LEFT: Extract characters from the left (used to return a specified number of characters from the first character of a text string).

13.RIGHT: take characters from the right (a specified number of characters returns the last character or characters in the text string).

14.TEXT: Text conversion function (returns a specific number of characters in a text string from a specified position specified by the user. )