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.         Enter the function required.   The function and the variables are stored when the function is set.

 

4.         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 values.

 

5.         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.

 

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

 

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