Difference between revisions of "Documentation/How Tos/Calc: AVERAGEA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 21: | Line 21: | ||
: returns <tt>'''1.5'''</tt>, the average of <tt>'''2'''</tt> and <tt>'''1'''</tt>. | : returns <tt>'''1.5'''</tt>, the average of <tt>'''2'''</tt> and <tt>'''1'''</tt>. | ||
− | + | {{Documentation/SeeAlso| | |
− | [[Documentation/How_Tos/Calc: AVERAGE function| | + | * [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]], |
− | [[Documentation/How_Tos/Calc: AVEDEV function| | + | * [[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]], |
− | [[Documentation/How_Tos/Calc: SUM function| | + | * [[Documentation/How_Tos/Calc: SUM function|SUM]], |
− | [[Documentation/How_Tos/Calc: COUNT function| | + | * [[Documentation/How_Tos/Calc: COUNT function|COUNT]], |
− | [[Documentation/How_Tos/Calc: DAVERAGE function| | + | * [[Documentation/How_Tos/Calc: DAVERAGE function|DAVERAGE]] |
− | [[Documentation/How_Tos/Calc: Statistical functions| | + | * [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]] |
− | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
− | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
Revision as of 13:31, 25 February 2009
AVERAGEA
Returns the average of the arguments, including text (valued as 0).
Syntax:
AVERAGEA(value1; value2; ... value30)
- value1 to value30 are up to 30 values or ranges, which may include numbers, text and logical values. Text is evaluated as 0. Logical values are evaluated as 1 (TRUE) and 0 (FALSE).
Example:
AVERAGEA(2; 6; 4)
- returns 4, the average of the three numbers in the list.
AVERAGEA(B1:B3)
- where cells B1, B2, B3 contain 4, 2, and apple returns 2, the average of 4 and 2 and 0.
AVERAGEA(2; TRUE)
- returns 1.5, the average of 2 and 1.