MoneyWorks Manual
Using Calculations in Transactions
As well as being able to enter numbers into transactions, you can also enter calculations. This is particularly useful if you need to work out the value that you want to enter.
To enter a calculation into a field:
- Tab to the field that you need to calculate
Type in the calculation
The first character in a calculation must be the equals sign (=).
- When the calculation is entered correctly, tab out of the field
MoneyWorks will evaluate the calculation that you have entered, and replace it with the result.
If you enter a calculation that cannot be evaluated (either because you have specified it incorrectly or because there is no valid answer as for example if you divide by zero), MoneyWorks will highlight the calculation that you have entered and beep. You will need to correct or replace it. Only the result of the calculation is recorded, the calculation expression is discarded.
You can enter calculations into virtually any field in a MoneyWorks entry screen. For example the result of a calculation in a date field will be converted to a date, in a numeric field to a number, and in a text field to a character string.
Example calculations:
| =(120+140)*.9 | Gives 234.00 |
| =1+2+3 | Gives 6.00 |
| ='1/1/03'+90 | Gives 1/4/03 |
| =(120+3 | Error, missing closing parenthesis |
| =(120+10)/0 | Technically an arithmetic error, but MoneyWorks will return 0. |