Double click on the cell in the quantity column of the template for which you want to define a formula. Editor and function selection open up in the lower screen area.
Enter a formula. Enter a value directly, or choose a function from the function selection (bottom right). Click on the function symbol, keep the left mouse key pressed and drag the function to the input screen of the editor (Drag&Drop).
What you do now depends on the type of function you selected (you cannot see the function type when you select the function):
Selected Function or Entry |
Further Steps |
Either you enter the values directly, or you have selected a function without parameters. |
Continue with step four. |
You have selected a function that has been assigned a table. You can see that this is the case when the narrow display frame
|
You define a flexible function (see above: Defining Flexible Functions and Realization of the Function ). After the definition, continue with step 4. |
Function with parameters. You can tell that a function has parameters because an additional window opens. The rows indicate the parameter type
|
Enter a value.
The values or functions available for selection are determined when the function is defined in the tab Function Use . |
To select a comparison operator, click on one of the
Operator Icons
in the header row of the editor.
Increase the editor screen towards the right so that you can see all the available operators.
Determine the
comparison operand 2
by entering a fixed value or choosing a function (see step 3). If you choose a function, display all the functions that are valid as comparison operand 2 by choosing
.
A first comparison has been entered. If you want to enter a second comparison, click on an icon in the editor that has the Boolean operators (AND, OR). To enter the next comparison, continue with step 3.
To format your entries, choose .
To check the formula, choose .
To transfer the entries in the editor, click on
Quantity
.
The entries in the editor are saved when you save the entire template.
For more information on working with the Editor, see Processing Possibilities in the Function Selection/Editor .