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

Kevin Bache
None
www.none.com

Sample input:

PaymentCalculator ( 1000 ; 6 )

Sample output:

166.67¶
166.67¶
166.67¶
166.67¶
166.66¶
166.66¶
¶

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// 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.
// Maximum of 9999 payments (limited by FileMaker).

Let ( 
         ThisPayment = If ( 
                                        Truncate ( Amount / NumberOfPayments ; 2 ) = Amount / NumberOfPayments ; 
                                        Amount / NumberOfPayments ;

                                        // Else
                                        Truncate ( Amount / NumberOfPayments ; 2 ) + .01
                                      ) ;

         If (
              NumberOfPayments = 0 ; 
              "" ; 
              
              // Else
              ThisPayment & "¶" & PaymentCalculator ( Amount - ThisPayment ; NumberOfPayments - 1 )
             )
      )

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.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

PaymentCalculator ( Amount ; NumberOfPayments )

Comments

Support this website.

Support this website.