Creating an account entry: calculator

Operators are executed from left to right with no particular priority. For example, =1+2x3 returns 9. Parentheses are accepted, so =1+(2x3) returns 7.

The Power operator can be used to calculate compound interest. Thus, =1.05^6x1000 returns the future value of an amount of 1000 francs at 5% interest for 6 years.

The result of the calculations is always positive: =5-7 returns 2 and not -2.

A formula can contain an account number in quotation marks ("" or "«») to obtain its balance (also always positive). For example, ="1000" returns the balance of the Cash account and ="1500 "x0.1 returns the 10% depreciation value of the Machines account. The account number can contain the wildcard character (@) to replace one of the account digits: ="1@"-"2@" returns the difference between all asset and liability accounts, i.e. the profit or loss.

An executed formula can be recalled by re-entering the = sign. If the formula has been entered in the wrong field, simply re-enter the = sign in the desired field.