EasyMorph Help

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== MRound(number, grain) ======
Category:  Number function

\\ 
=====Description=====
This function rounds a number to the desired multiple (//grain//). 

\\ 
=====Arguments=====
^Argument^Type^Description^
|number|Number|The value, usually fractional, to be rounded.|
|grain|Number|The multiple to round //number// to.|
\\ 
**Return value type:**  Number

\\ 
=====Remarks=====
MRound uses "bankers rounding" which rounds a value ending in 5 to the nearest //even// value. This behavior is slightly different from that of the mround() function in Excel which always rounds away from zero.


\\ 
=====Examples=====

  mround(5.3, 0.5) //Returns 5.5

  mround(10.05, 0.1) //Returns 10.0 (bankers rounding rounds to the closest even value)

  mround(10.15, 0.1) //Returns 10.2 (bankers rounding rounds to the closest even value)

  mround(20.78, 1) //Returns 21

  mround(57, 15) //Returns 60

\\ 
===== See also =====
  * [[syntax:functions:ceiling|Ceiling(number)]]
  * [[syntax:functions:floor|Floor(number)]]
  * [[syntax:functions:round|Round(number, dec_places)]]
  * [[syntax:functions:roundxl|RoundXL(number, dec_places)]]
  * [[syntax:functions:truncate|Truncate(number)]]