What is the function of AVERAGE function

The function of the AVERAGE function is to find the average of each parameter specified in parentheses.

Grammar form:

AVERAGE( number, number2,……)

Parameter description:

Number,, number2, are 1~30 parameters to be calculated. These arguments can be numbers, or names, arrays, or references involving numbers. If there are literals, logical values, or empty cells in the array or cell reference parameters, their values ​​are ignored. However, if the cell contains a zero value it is counted.

For example, enter the formula in cell B8: =AVERAGE(B7:D7,F7:H7,7,8). After confirmation, you can find the values ​​in the areas B7 to D7 and F7 to H7. Value and the average of 7 and 8.

The AVERAGE function is the average calculation function in the EXCEL table. The abbreviation avg is used for average in the database. AVERAGE is the average value of the returned parameters (also the arithmetic mean). For example, if the range (Area: two or more cells on a worksheet. Cells in a range may or may not be adjacent) A1:A20 contains numbers, the function =AVERAGE(A1:A20) will return these The average of numbers.

Recommended tutorial: excel tutorial

The above is the detailed content of What is the function of AVERAGE function. For more information, please follow other related articles on the PHP Chinese website!