MROUND(number,multiple)

Returns a number rounded to the desired multiple.

number is the value to round.

multiple is the multiple to which you want to round number.

MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.

MROUND(10, 3) = 9
MROUND(-10, -3) = -9
MROUND(1.3, 0.2) = 1.4

See also:

ROUND

 
Site Map
Features> Functions>
Copyright © 2001-2008 by HydeSoft Computing, LLC
Privacy Policy