Home : AVG
Q10676 - INFO: AVG

AVG returns the average (arithmetic mean) of the specified cell range

AVG(Cell Range):

Cell Range:  The cell range to anaylze. i.e. (A1:A31) 

NOTES:

The AVG function handles data qualifers with default rules of:

< are treated as zeros (<2 = 0, <100 = 0)
> are treated as entered value (>4 = 4, >1000 = 1000)
ND are treated as zeros

If you need to specify different rules for data qualifiers use GAVGZ or STATZ

The AVG function takes the average of the displayed values in the cell, use AVERAGE to use the values in the cell.  Example, if you have two cells, one is equal to 22/7 (3.14159...)  and displayed to zero decimal places (i.e. 3) and the second cell is equal to 1.  AVG will take the average of 3 and 1 and return exactly 2.0000 whereas AVERAGE will take the average of 3.14159 and 1 and return 2.0714... 

EXAMPLES:

AVG(C4:C22)

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/27/2008 9:01 PM.
Last Modified on 4/14/2023 9:46 AM.
Last Modified by Scott Dorner.
Article has been viewed 2928 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article