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
Soliant Consulting
https://www.soliantconsulting.com/

Sample input:

MRound ( 10 ; 3 )

Sample output:

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

/**
 * @SIGNATURE:
 * MRound ( number ; multiple )
 *
 * @PARAMETERS:
 * number - Required. The value to round.
 * multiple - Required. The multiple to which you want to round number.
 *
 * @HISTORY:
 * Created: 2019-01-02 by Mislav Kos <mkos@soliantconsulting.com>
 *
 * @PURPOSE:
 * MRound returns a number rounded to the desired multiple.
 *
 * @RESULT:
 * A number rounded to the desired multiple.
 * Returns "?" if either parameter is missing, if the multiple is 0, or if the two parameters do not have the same sign.
 *
 * @ERRORS:
 * The number and multiple parameters must have the same sign. If not, this custom function returns an empty string.
 * 
 * @DEPENDENCIES:
 * None
 *
 * @NOTES:
 * This custom function is similar to Excel's MROUND function: https://support.office.com/en-us/article/mround-function-c299c3b0-15a5-426d-aa4b-d2d5b3baf427
 */

Let ( [ 
	_number = GetAsNumber ( number ) ; 
	_multiple = GetAsNumber ( multiple ) 
] ; 
	If ( 
		// validate that neither parameter is empty
		IsEmpty ( _number ) or IsEmpty ( _multiple ) 
		
		// validate that the multiple is not 0
		or _multiple = 0 
		
		// validate that the two parameters have the same sign; e.g. _number can't be negative if _multiple is positive
		or _number * _multiple < 0 ; 
		
		// return ? if validation fails
		"?" ; 
		
		Round ( _number / _multiple ; 0 ) * _multiple 
		
	)
)

MRound returns a number rounded to the desired multiple.

Examples:
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.

Comments

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

MRound ( number ; multiple )

Comments

Support this website.

Support this website.