Brian Dunning's FileMaker Custom Functions

QuarterRound ( NUM )

Rounds numbers to nearest quarter (0, .25, .5, .75)

  Average rating: 4.3 (31 votes) Log in to vote

Josh Morton   Josh Morton
JEM CONSULTING

Share on Facebook Share on Twitter

  Sample input:
QuarterRound(1.1)
QuarterRound(1.1934)
QuarterRound(1.4)
QuarterRound(1.61345)
QuarterRound(1.6934)
QuarterRound(1.934)
  Sample output:
1
1.25
1.5
1.5
1.75
2

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

Rounds numbers to quarters. (0, .25, .5, .75)

Good for working with inches or pricing

 

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.