MRound ( number ; multiple )
Similar to the Excel function, MRound returns a number rounded to the desired multiple.
Be the first to rate this function Log in to vote
Mislav Kos - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
MRound returns a number rounded to the desired multiple.
MRound ( 10 ; 3 ) = 9
MRound ( -10 ; -3 ) = -9
MRound ( 1.3 ; 0.2 ) = 1.4
MRound ( 2.2 ; 0.5 ) = 2
MRound ( 2.3 ; 0.5 ) = 2.5
The two parameters must be numbers, and they must have the same sign. The 'multiple' parameter cannot be zero. The custom function will return "?" if parameter validation fails.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.