Manuals/calci/AVERAGE

From ZCubes Wiki
Revision as of 20:30, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">'''AVERAGE''' (A1, A2...)</fo...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
AVERAGE (A1, A2...) A1, A2 ...   are positive integers.

AVERAGE is a function that calculates the average (arithmetic mean) of the arguments.


·        Arguments can be numbers, names, arrays, or references.

·        Logical values and text representations of numbers are calculated.


AVERAGE 

Let’s see an example

AVERAGE (A1, A2…….)

B

12

16

5

18

=AVERAGE (B2:B5) is 12.75

=AVERAGE (B2:B5,4) is 11


Syntax

Remarks

Examples

Description

Column1 Column2 Column3
Row1 12 12.75
Row2 16 11
Row3 5
Row4 18
Row5
Row6
'