writer
1,835
edits
Changes
Jump to navigation
Jump to search
Line 39:
Line 39: − * The AVERAGEA function takes a column and averages the numbers, but also handles non-numeric data types according to the following rules:+ − + − + − +
Manuals/calci/Average, AverageA, AverageX Example (view source)
Revision as of 01:08, 20 September 2021
, 01:08, 20 September 2021no edit summary
<div style="font-size:16px">'''NOTE:'''</div>
<div style="font-size:16px">'''NOTE:'''</div>
The AVERAGEA function takes a column and averages the numbers, but also handles non-numeric data types according to the following rules:
*It support Logical values.
*It support Logical values.
*Logical value TRUE count as 1 & FALSE count as 0 (zero).
*Logical value TRUE counts as 1 & FALSE counts as 0.
*Values that contain non-numeric text count as 0 (zero).
*Values that contain non-numeric text count as 0.
*Empty text (“”) counts as 0 (zero).
*Empty text ("") counts as 0.
'''AVERAGEA(A2:A5) = 2.5<br>
'''AVERAGEA(A2:A5) = 2.5<br>
'''AVERAGEA(B2:B5) = 1333.33<br>
'''AVERAGEA(B2:B5) = 1333.33<br>
'''AVERAGEA(D2:D5) = 0.5<br></br>
'''AVERAGEA(D2:D5) = 0.5<br></br>