Brian Dunning's FileMaker Custom Functions

TriangleNumber ( n )

Returns a Triangle Number

  Average rating: 4.6 (30 votes) Log in to vote

Steven McGill   Steven McGill
Computech IT Services
http://www.computech-it.co.uk

Share on Facebook Share on Twitter

  Sample input:
TriangleNumber ( 5 )
  Sample output:
15

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

A triangular number or triangle number counts the objects that can form an equilateral triangle, as in the diagram on the right. The nth triangle number is the number of dots in a triangle with n dots on a side; it is the sum of the n natural numbers from 1 to n.
http://en.wikipedia.org/wiki/Triangular_number

n = 5 returns 1+2+3+4+5 = 15

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.