icon of
Reporter ToolBox.
It is function to calculate the maximum 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 '@max(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 maximum value uses following format.
-Function definition : double max(cell 1 : cell 2)
-Function parameter : Specific number of cell to get the maximum value.
-Result : The calculated maximum value.
Example of written function) =@max(B2:C3);
Function description : It displays the maximum value of cell B2, B3, C2, C3.
Relate items)