writer
1,835
edits
Changes
Jump to navigation
Jump to search
Manuals/calci/Average, AverageA, AverageX Example (view source)
Revision as of 00:46, 20 September 2021
, 00:46, 20 September 2021Created page with "<div style="font-size:30px">'''DATA'''</div><br/> {| class="wikitable" |+Spreadsheet |- ! !! A !! B !!C !!D |- ! 1 | ID || Amount || Blank || Boolean || SalesDate ||..."
<div style="font-size:30px">'''DATA'''</div><br/>
{| class="wikitable"
|+Spreadsheet
|-
! !! A !! B !!C !!D
|-
! 1
| ID || Amount || Blank || Boolean || SalesDate || Name
|-
! 2
| 1 || || || TRUE || 29/5/2020 || A
|-
!3
| 2 || 1000 || || FALSE || || B
|-
!4
| 3 || 2000 || || TRUE || 29/5/2020 ||
|-
!5
| 4 || 1000 || || FALSE || 28/5/2020 || C
|}
='''AVERAGE([A1:A5])<br></br>
<div style="font-size:30px">'''AVERAGEA ()'''</div><br/>
*Parameters are values or range of cells containing values.
**AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.
== Description ==
{| class="wikitable"
|+Spreadsheet
|-
! !! A !! B !!C !!D
|-
! 1
| ID || Amount || Blank || Boolean || SalesDate || Name
|-
! 2
| 1 || || || TRUE || 29/5/2020 || A
|-
!3
| 2 || 1000 || || FALSE || || B
|-
!4
| 3 || 2000 || || TRUE || 29/5/2020 ||
|-
!5
| 4 || 1000 || || FALSE || 28/5/2020 || C
|}
='''AVERAGE([A1:A5])<br></br>
<div style="font-size:30px">'''AVERAGEA ()'''</div><br/>
*Parameters are values or range of cells containing values.
**AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.
== Description ==