Have you tried setting the format of the over/short filed to "None" to see what is being placed into the field?
You could also print the value to the console or pop an alert with the computed value.
My guess is the value will be "NaN", Not a Number, because there is a null or blank field in one of the fields you are usng in a prior calculation.
The fields Over and Short could show a negative value. But negative values need to show as 0 and calculate as 0. Only one of these fields can have a value other than 0(this is a either or situtation). I have tried showing the format as none with the same result.
What are the values your are getting for all the involved fields?
Are the results of your calculations correct?
Exactly what field is throwing the error?
1 + 2 + 3 + 4= 10
or with 3 as a string:
1 + 2 + "3" + 4 = 334
The fields involve are totals of currency. There are 4 columns that are added together to come up with a TotalCash sum. In another area I have a field named OldBalance that together with a field named CashIn(+) and CashOut(-) gives the sum of NewBalance. The sum of NewBalance should equal the Sum of TotalCash if not then either the Over or the Short field should have a sum plugged, therefore; Over or Short can not show a negative number or sum a negative number.
The calculations for the NewBalance is correct. The calculation for TotalCash is correct. The problem is that when you plug the number into CashOut the error messages comes up. If you answer ok to the 2 error messages and then delete the numbers in the over or short field the Total field is correct. If not the number that should have cleared when entering the CashOut field stays and caused the Total field to be out of balance. I should add that if the sheet is out of balance that it will not let you clear the field.
I tried changing the format to none and the same errors popped up.