Defining Formulas

Procedure

1. 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.
2. 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).
3. 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 Flexible Function Condition opens up. 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 normal or optional (see selection in the far right-hand column and Function Parameters under Parameter Type and Default Value). Enter a value. For fixed values: Enter the value directly or select F4. For functions/variables: You move a function from the selection to the Parameter Value field using Drag&Drop. Transfer your entries by choosing in the parameter dialog box. The values or functions available for selection are determined when the function is defined in the tab Function Use.
1. To select a comparison operator, click on one of the Operator Icons in the header row of the editor.
2. Increase the editor screen towards the right so that you can see all the available operators.

3. 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 .
4. 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.
5. To format your entries, choose .
6. To check the formula, choose .
7. To transfer the entries in the editor, click on Quantity.
8. 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.