MROUND Function in Excel

In this post, you will learn about the MROUND Function, how to use it in your excel spreadsheets.

MROUND Function in Excel

The MROUND function returns a rounded number with a given multiple. The function will round off the numbers either up or down depending on the multiple.

This is one of the rounding off functions in excel like the Ceiling and Floor function.

Syntax

=MROUND(number, significance)

The syntax has two arguments

  • number – The number that you want to round up; Required
  • significance – The multiple to which you want to round the number; Required

How to use MROUND Function in Excel?

  • The function returns the nearest multiple of the given multiple.
  • Both the arguments in the syntax can be positive or decimal numbers.
  • Note that the number is rounded up according to the multiples and not the number itself Example =CEILING(10, 3) answer is 9 a multiple of 3.
  • The function selects the closest multiple to the given number as the answer, whether it is greater or lesser.
  • Sometimes when the significance value is 1, the function returns the number unchanged as the answer. This happens when there is no need to round up the number as it satisfies the significance value.

Examples

Start with the data. Then in a new cell enter the syntax and highlight the data to insert it in the syntax.

How to use MROUND Function in Excel?

Press enter to display the answer and use the fill handle to apply the function to the rest of the data.

How to use MROUND Function in Excel?

Additional points:

  • The function does not work when one of the arguments is a negative number and returns #NUM!.
  • When both the arguments are negative the syntax works, and the answer is displayed.
How to use MROUND Function in Excel?
  • The syntax returns #VALUE! when the argument is a non – numeric value.
MROUND Function in Excel
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.