icon
of Reporter ToolBox.
It is function to calculate the maximum of absolute value(always positive 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 '@AbsMax(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 of absolute value uses following format.
-Function definition : double AbsMax(cell 1 : cell 2)
-Function parameter : Specific number of cell. (start / end location)
-Result : The calculated absolute value.
Maximum of absolute value is same with setting method for Maximum Value function, except that this function is absolute value.
Example of written function) =@AbsMax(C2:D3);
Function description : It displays the maximum of absolute value for C2, C3, D2. D3 cell.
Relate items)