1, summation function:
The SUM function is used for summation. The function formula is = =sum ().
For example, calculate a cell range: = sum (A 1: A 10) and calculate multiple cell ranges: = sum (A 1: A 10, c10).
2. Average function:
The function of the average is to calculate the average. The function formula is = =AVERAGE ().
For example, calculate the average of multiple cells = average (A 1: A 12).
3. Counting function:
Function is used to count the number of cells. The function formula is = =COUNT ().
For example = count (a 1: a 12).
4.IF function:
The function of IF is to judge a condition and then return the specified value according to the judgment result.
The formula of IF function is: = if (logical judgment, true time result, false time result).
For example, the given condition is a1>; A5, if the comparison result is true.
Then the IF function returns the value of the second parameter; If FALSE, the value of the third parameter is returned. = IF(a 1 & gt； 5 1，2).
5. Now function and today function:
The NOW function returns the date and time. TODAY function only returns the date.
NOW function and TODAY function have no parameters, just a pair of brackets: = now () = today ().
For example, how many days did a project last today? = today()- start date, and the number obtained is the number of days that the project has been carried out.