Set Function

Simple functions can be set up and then executed on example rows, input/output columns, a selected cell or a range of cells.

 

1.         Position the grid cell marker on the Grid row or column from where you want to set the values.

 

2.         Click the right mouse button and select Set Function.

 

3.         Click the Next button to select the function or enter the function required and click the Add button.

 

4.         Click the Close button to store the function and variables and close the dialog.

 

5.         Position the Grid marker on the Grid row or column where you want to change the values.   This can be the same position as the one already selected for setting the function.

 

6.         Click the right mouse button again and select Execute on Example Row, Execute on Input/Output Column, Execute on Selected Grid Cell or Execute on Range. The range of example rows or input/output columns can be restricted with Set Range.

 

7.         The function is tested on the row, column or cell to see if it produces valid results.

 

8.         If the test is successful the function is executed and the results are put into the Grid row, column or cell.