MROUND
Formulas / MROUNDRound 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?
How Does the MROUND Function Work?
What are Some Examples of Using 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.
