Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > MROUND
 

MROUND(number, multiple)

 
 Returns a number rounded to the desired multiple.

 numberThe number you want to round.
 multipleThe multiple to which you want to round.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• This function rounds up, if the remainder of dividing "number" by "multiple" is greater than or equal to half the value of "multiple".
     
  		• This function rounds down, if the remainder of dividing "number" by "multiple" is less than half the value of "multiple".
     
  		• If "number" and "multiple" have different signs, then #NUM! is returned.

     EXAMPLES
     
     A
    1=MROUND(10,3) = 9
    2=MROUND(-10,-3) = -9
    3=MROUND(1.58,0.5) = 1.5
    4=MROUND(1.3,0.2) = 1.4
    5=MROUND(1234,100) = 1200
    6=MROUND(1234,1000) = 1000
    7=MROUND(5,-2) = #NUM!
    8=MROUND(-5,2) = #NUM!
    9=MROUND(10,"some text") = #VALUE!
    		 
     Functions - M | Index - M | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top