Range ( start ; stop ; increment )

Creates a value list from the 'start' value to the 'stop' value by the 'increment.'

Average rating: 5.0 (2 votes) Log in to vote

Ethan - Show more from this author
DB Services
https://dbservices.com/about/people/ethan-yoder/

Sample input:

Example 1:
Range ( 10 ; 30 ; 10 )

Example 2:
Range ( 0 ; -4 ; -2 )

Sample output:

Example 1:
10
20
30

Example 2:
0
-2
-4

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

Case (
	step = 0 ;
	"?" ;

	( stop < start ) and step > 0 ;
	"" ;

	( stop > start ) and step < 0 ;
	"" ;

	( stop < start + step ) and step > 0 ;
	start ;

	( stop > start + step ) and step < 0 ;
	start ;

	// else
	start & ¶ & Range ( start + step ; stop ; step )

)

This function also works for numbers, dates, and times. Can go backwards as well.

Comments

		Ethan, Tactile Medical Apr 6, 2022
The parameter "increment" should be "step".

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

Range ( start ; stop ; increment )

Comments

Support this website.

Support this website.