[Calc] Function to compute average of a range
Posted: Tue Apr 18, 2017 2:23 pm
Can somebody help me ?
The following is the question:
Function ComputeAverage(firstRow As Long, lastRow As Long) As Double
The aim of this function is to calculate the average of a section of data in Column A
For example, a call of ComputeAverage(4,10) in your OO Basic program should return the average of the cells from A4 to A10
You can make use of the constant DATA_COL (=1) in this function to refer to Column A
The first input firstRow is the row number of the starting row
The second input lastRow is the row number of the last row
Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).
The following is the question:
Function ComputeAverage(firstRow As Long, lastRow As Long) As Double
The aim of this function is to calculate the average of a section of data in Column A
For example, a call of ComputeAverage(4,10) in your OO Basic program should return the average of the cells from A4 to A10
You can make use of the constant DATA_COL (=1) in this function to refer to Column A
The first input firstRow is the row number of the starting row
The second input lastRow is the row number of the last row
Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).