Function: MRound

Description

Rounds number to the nearest multiple of number2.

Syntax

MRound(number,[number2])

Arguments

number is the value to be rounded. The number can be a constant, a numeric field, an expression that results in a number or a function that returns a number.

number2 is the optional multiple to which number is to be rounded. If this is not specified then it defaults to 1.0 (or -1.0) causing rounding/truncating to the nearest integer

Return value

This function returns a number. If number2 is zero, or if the sign of number2 differs from the sign of number then these functions return a null value.

Calculated field examples

If the Unit_price field contained the value 2.5, the following calculated field expression would return the number 3: MRound(Unit_price,1)

If the Unit_price field contained the value 12.46, the following calculated field expression would return the number 12.50: MRound(Unit_price,0.25)

Filter/Find example

Records with a Unit_price field value of 34.70 or 35.17 can be selected or found using the expression: MRound(Unit_price,0.50)=35