RoundToMultiple ( number ; precision )
Round a number to the nearest multiple of a given precision
Average rating: 4.4 (35 votes) Log in to vote
Menno van Beek
Van Beek Zakelijke Software
RoundToMultiple ( 1.78 , 2 )
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Round a number to the nearest multiple of a given precision.
The precision may not equal zero. A negative or positive precision gives the same result.
The result of this function is similar to bankersrounding, except that you can choose any precision:
RoundToMultiple ( 1.045 ; 0.02 ) <=> 1.04
RoundToMultiple ( 1.055 ; 0.02 ) <=> 1.06
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.