icon of
Reporter ToolBox.
It is function to calculate the average value, between specific start and end cell location.
If you select the 'Insert | Function' after selecting the cell (one or several), Insert Function dialogue box comes up.
After inserting the '@ave(A0:A3)' at Insert Function dialogue box, you can
modify this function by using the Cell Text
Edit dialogue box. This dialogue box comes up by selecting the 'Form | Cell
| Cell Text' or
icon of
Reporter ToolBox.
Also, you can insert this function by using the Cell Text Edit dialogue box, without Insert Function dialogue box.
Function for average value uses following format.
-Function definition : double ave(cell 1 : cell 2)
-Function parameter : Specific number of cell to get the absolute value.
-Result : The calculated absolute value.
<Figure 1> is example of 'View as run mode' for average value function.
<Figure 1> Example of 'View as run mode' for average value function
Example of written function) =@ave(A0:A7);
Function description : It displays the average value of A0, A1, ... A7 cell ( (A0+A1+ ...A7) / 8 value ).
Relate items)