Its value is valid from the position in the text at which you insert it to the end of the text – unless you assign another value to the PRICE variable further down in the text.
The entry as a whole defines the variable PRICE and sets it to 17.99. The "formula" here is only the constant value 17.99. You can insert any of the variables in the formula by double-clicking on them. Tip: In the dialog box of the ribbon command Insert | Field | Calculation, all currently defined variables appear in the list Variable/field. The result of a formula can be assigned to a variable.
Thus, the argument for functions can be a different function, any calculation, a database field, a table cell and, of course, a combination of all of them. If B has the value 3752.70, the formula produces the value 3. Here, the FUNCTION INT, which removes the decimal places of a value, is applied to the calculation B/1000. On September 16, 2018, the formula would thus produce the value 9. However, this result is immediately evaluated by the MONTH() function, which returns only the month of the date (as a number). The function TODAY() returns the current date. Here, one function is applied to another. On September 16, 2018, for example, it would return 09/16/18. For detailed descriptions, see Computational functions. TextMaker also provides a number of computational functions. If NUMBER is currently 10, the formula returns 50. In this formula, the fixed value 5 is multiplied by the NUMBER variable. This always returns the fixed value 30, and it is actually a fixed value and not a calculation. You can also use the contents of database fields, table cells and objects in formulas.įor more information, see Table cells in calculations, Database fields in calculations, and Objects in calculations.Ī formula can contain different types of calculations. The date "01.01.29" is thus interpreted as 1.1. For years between 30 and 99, TextMaker prefixes "19.".
If you enter a two-digit year between 0 and 29, TextMaker automatically prefixes "20.".