PaymentCalculator ( Amount ; NumberOfPayments )
Returns a return-delimited list of payment amounts rounded to the nearest penny. The remainder of the division is evenly distributed a penny at a time among the first payments.
Average rating: 4.4 (37 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Divides Amount by NumberOfPayments, rounding to .01.
Distributing remainder evenly among the first payments .01 at a time so that all payments are as even as possible.
Contains a trailing "¶". Inputs can be numbers formatted as text or numbers.
Maximum of 9999 payments, at least on my computer which has 512MB of RAM.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.