Difference between revisions of "Documentation/How Tos/Calc: AVERAGE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m (→Issues:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 17: | Line 17: | ||
: where cells <tt>'''B1'''</tt>, <tt>'''B2'''</tt>, <tt>'''B3'''</tt> contain <tt>'''1'''</tt>, <tt>'''3'''</tt>, and <tt>'''apple'''</tt> returns <tt>'''2'''</tt>, the average of <tt>'''1'''</tt> and <tt>'''3'''</tt>. Text is ignored. | : where cells <tt>'''B1'''</tt>, <tt>'''B2'''</tt>, <tt>'''B3'''</tt> contain <tt>'''1'''</tt>, <tt>'''3'''</tt>, and <tt>'''apple'''</tt> returns <tt>'''2'''</tt>, the average of <tt>'''1'''</tt> and <tt>'''3'''</tt>. Text is ignored. | ||
− | + | {{Documentation/SeeAlso| | |
− | [[Documentation/How_Tos/Calc: AVERAGEA function| | + | * [[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]], |
− | [[Documentation/How_Tos/Calc: GEOMEAN function| | + | * [[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]], |
− | [[Documentation/How_Tos/Calc: HARMEAN function| | + | * [[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]], |
− | [[Documentation/How_Tos/Calc: MEDIAN function| | + | * [[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]], |
− | [[Documentation/How_Tos/Calc: MODE function| | + | * [[Documentation/How_Tos/Calc: MODE function|MODE]], |
− | [[Documentation/How_Tos/Calc: TRIMMEAN function| | + | * [[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]], |
− | [[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]]}} |
===Issues: === | ===Issues: === | ||
− | * Calc assumes that [[Documentation/How_Tos/Calc: Logical functions#Logical values overview|logical values]] are <tt>'''1'''</tt> (<tt>'''TRUE'''</tt>) and <tt>'''0'''</tt> (<tt>'''FALSE'''</tt>). Excel ignores logical values. | + | * Calc assumes that * [[Documentation/How_Tos/Calc: Logical functions#Logical values overview|logical values]] are <tt>'''1'''</tt> (<tt>'''TRUE'''</tt>) and <tt>'''0'''</tt> (<tt>'''FALSE'''</tt>). Excel ignores logical values. |
Revision as of 13:30, 25 February 2009
AVERAGE
Returns the average of the arguments, ignoring text.
Syntax:
AVERAGE(number1; number2; ... number30)
- number1 to number30 are up to 30 numbers or ranges containing numbers.
Example:
AVERAGE(2; 6; 4)
- returns 4, the average of the three numbers in the list.
AVERAGE(B1:B3)
- where cells B1, B2, B3 contain 1, 3, and apple returns 2, the average of 1 and 3. Text is ignored.
Template:Documentation/SeeAlso
Issues:
- Calc assumes that * logical values are 1 (TRUE) and 0 (FALSE). Excel ignores logical values.