The position number must be an integer (#xx#)!
Balance Formula Testing checks for general formatting correctness of the formula, in addition to checking whether an acceptable expression has been entered between the loci (#) in the expression.
Thus, the reference to the value of the positions in columns A or B is subject to the regulation:
| In first place |
Follow |
|
A - value of column position A (Formula 1)
B - the value of the position of column B (Formula 2)
|
position number, e.g.: 10
Only integers make sense here, using special characters does not. The formula test returns this error in this case.
|
Similarly, testing bookkeeping-template formulas is done there, except that only column A is allowed, and column B does not exist.
Expressions that fail the logic check are also printed, and formula testing puts us on the disputed notation so we can fix it more easily.
When you click the 
button, the program places the cursor at the point in the formula where the error occurred.
The following solution is available. Enter the correct sequence number of the position you are referring to in the formula.
| Correct |
Incorrect |
| #A31#+#A32# |
#A3%# |
| #A31#+#A32# |
#A3[1,2]# |
| #A31# |
#A# |