icon
of Reporter ToolBox.
It is function to calculate the subtraction value of horizontal 2 cells of which vertical cell is variable, such as AI Multi Ave, AI Multi Sub, ...AI Alarm, AI Period Data, DI Multi On Time,... DI ON/OFF List etc. (Data Object for Multiple Lines)
If you select the 'Insert | Function' after selecting the cell (one or several), Insert Function dialogue box comes up.
After inserting the ¡®@LineSub(A:C)¡¯ 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 of subtraction value for lines uses following format.
-Function definition : double LineSub(cell 1 : cell 2)
-Function parameter : Specific number of first and second cell to be used to subtraction.
-Result : First cell - Second cell. (multiple lines)
@LineSub function uses in case of subtracting the first cell to second cell horizontally, as same method with @LineAve function.
Example of written function) =@LineSub(D:G);
Function description : It displays all subtraction values which are multiple lines object (D cell - G cell value) at multiple lines which you specify.
Relate items)
Data Object for Multiple Lines
Average Value of Lines(@LineAve)