Home > Topics > excel > What is the function of AVERAGE function

What is the function of AVERAGE function

王林
Release: 2020-05-12 14:27:59
Original
32581 people have browsed it

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,……)
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template