< Go Back

Excel MROUND Function

The function of MROUND in Excel is used to return the number that has been rounded up to the given multiple numbers. This function rounds the number either up or down and that depends on the nearest multiple.

The main purpose of this function is to round the numbers to the nearest multiple and the return display is the rounded number.

Figure 1: Excel MROUND Function

The syntax of the function

The syntax of the MROUND function is as follows:

=MROUND (num, multiple)

The argument breakage in this syntax is:

  • Num – the number that needs to be rounded
  • Multiple – the multiple to be used

Usage of the function

  • MROUND always rounds up away from zero
  • The #NUM error is shown when the numbers and multiples are not of the same sign
  • The numbers and multiples must be of the same sign

Example

In the given example figure, the number argument is the cell no B5 and the multiple is the cell C5. Both these arguments will return the display of the nearest possible multiple.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar