Rounding a number with MROUND function: MROUND is a very useful function when it comes to rounding a number to desired multiple. MROUND formula works as below: =mround(number,multiple) NUMBER: It is the value that you wants to round MULTIPLE: The NUMBER provided above will be rounded with respect to MULTIPLE factor mentioned here. Important: Both NUMBER and MULTIPLE needs to be either positive or negative. This function will generate error if one is positive and other is negative or vice versa. Lets see few example of Mround below: Example-1: Cell A1 = 494.60 Formula = Mround(A1,0.25) Result=494.50. It converted the number to divisible by 0.25 and .60 has become .50 Example-2: Cell A1 = 494.60 Formula = Mround(A1,1) Result=495. It converted the number to divisible by 1 as mentioned in second argument. Number appearing after decimal is now eliminated Example-3: Cell A1 = 494.60 Formula = Mround(A1,5) Result=495. Number is now divisible by 5. Example-4: Cell A1 = 494.60 Formula = Mround(A1,10) Result=490. Number is now divisible by 10. Example-5: Cell A1 = 494.60 Formula = Mround(A1,100) Result=500. Number is now divisible by 100.
Posted on: Fri, 02 Aug 2013 16:28:39 +0000
Trending Topics
Recently Viewed Topics
© 2015