icon of Reporter ToolBox.
It is function to get the specific vertical cell text of horizontal minimum value address, 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 ¡®@MinCellText(A, B0:B3)¡¯ 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 text of minimum value cell uses following format.
-Function definition : double MinCellText(Horizontal cell number to get the text, cell 1 : cell 2)
-Function parameter : Horizontal cell number to get the text(A, B, C etc), Start cell(B0, C2 etc) specific number : End cell(B3, C12 etc) specific number.
-Result : It gets the horizontal cell specific number text of vertical cell which minimum value generated.
Example of written function) =@MinCellText(A, B1:B10);
Function description : It displays the A cell value which is located in cell location of minimum value of B1 ~ B10 at current cell.
If the minimum value is in B3 cell of B1 ~ B10, it displays the A3 cell text at current cell.
Relate items)