Formulas

Mathematical formulas can be entered in the debit and credit cells for each line. These formulas are assumed to compute the associated amounts from data entered in the preceding lines. The following syntax has to be used for these formulas:

      S means that the cell debit or credit is selected by default,

      Dx or Cx correspond to the debit or credit amounts from the line ; for example C1 is equal to the credit amount of the first line whereas D4 is equal to the debit amount of the fourth line.

      It is also possible to consider sums of values, for example, D1:4 and C5:7, respectively corresponding to the sum of debits of the lines 1 to 4 and to the sum of credits of the lines 5 to 7.

      Numerical values can also be entered, as, for example, 0.196,

      Formulas can include parentheses, as for example, (C1+C5-D2:4)*0.196-(C6+C8),

      The admissible operators are as follows: +, -, *, /.