I have a calculated result that can be plus or minus 1cent, how can I shown this as zero cents. Or better yet I have a scheduled payment that can be a split payment into two or three payments (this is chosen from a drop down list), but when divided I can end up with the total being plus or minus one cent. Ideally the last payment should reflect the one cent difference. How do I show this calculation when there is not a field for this amount except when it is brought into a payment received. Hope I made myself clear.

OK. We multiply by 100 to calculate, then divide by 100 to get the exact amount(s). For example:

result:

1764.81

1764.82

.01

1764.8133333333333333

Your first payment(s) would use the

Floor(num*100/3)/100and the final would be theCeiling(num*100/3)/100I used the Mod(num*100 ; 3)/100 to show the difference that would be lost by rounding alone. And I showed the long decimal if only dividing. But you should only need the two calcs with Floor() and Ceiling().

So your script (revised a bit) would be:

Beverly