MROUND

Formulas / MROUND
Round a number to the nearest multiple.
=MROUND(number,multiple)
  • number - required argument that is the number to round
  • significance - required argument that is the number to use when rounding

Examples

  • =MROUND(10,3)

    This example will round up the number 10 to the nearest multiple of 3. In this case, the result will be 9.

  • =MROUND(10,4)

    This example will round up the number 10 to the nearest multiple of 4. In this case, the result will be 12.

  • =MROUND(119,25)

    This example will round up the number 119 to the nearest multiple of 25. In this case, the result will be 125.

  • =MROUND(-10,-3)

    This example will round up the number -10 to the nearest multiple of -3. In this case, the result will be -9.

  • =MROUND(-10,-4)

    This example will round up the number -10 to the nearest multiple of -4. In this case, the result will be -12.

  • =MROUND(-119,-25)

    This example will round up the number -119 to the nearest multiple of -25. In this case, the result will be -125.

Summary

The MROUND function is used to round a number to a multiple. It takes two arguments, the number to round and the number to use when rounding. It rounds up or down depending on the multiple and rounds to the nearest integer or negative number. It's also useful for rounding prices to .99.

  • The MROUND function takes two arguments: number and significance. The number argument is the number to round and the significance argument is the number to use when rounding.
  • MROUND rounds up or down depending on the nearest number, and it rounds to the nearest negative number.
  • For pricing purposes, MROUND rounds to the nearest .99.


Frequently Asked Questions

What is the MROUND Function?
The MROUND function is a function in Sourcetable used to round numbers to the multiple specified.
How Does the MROUND Function Work?
The MROUND function works by rounding the number to the nearest multiple. If the remainder of dividing the number by the multiple is greater than or equal to half the value of the multiple, then the MROUND function will round up.
What are Some Examples of Using the MROUND Function?
The MROUND function can be used in a variety of scenarios. Here are some examples of the MROUND Function:
  • If the number is 45 and the multiple is 10, the result of the MROUND function would be 50.
  • If the number is 29 and the multiple is 10, the result of the MROUND function would be 30.
  • If the number is 23 and the multiple is 5, the result of the MROUND function would be 25.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV