icon
of Reporter ToolBox.
It is function to calculate the minimum 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 '@AbsMin(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 minimum of absolute value uses following format.
-Function definition : double AbsMin(cell 1 : cell 2)
-Function parameter : Specific number of cell. (start / end location)
-Result : The calculated absolute value.
Minimum of absolute value is same with setting method for Minimum Value function, except that this function is absolute value.
Example of written function) =@AbsMin(F5:H7);
Function description : It displays the minimum of absolute value for F5, F6, F7, G5, G6, G7, H5, H6, H7 cell.
Relate items)