SheetFX
≡
<< Go back to all functions

MROUND

The MROUND function in Google Sheets is a convenient tool for rounding one number to the nearest integer multiple of another. Whether you're calculating dimensions, determining payment amounts, or working with time intervals, the MROUND function simplifies the task. Explore our comprehensive guide to learn how to effectively use this function.

Function Syntax and Parameters

Syntax: MROUND(value, factor)

Parameters:

  • value: The number you want to round.
  • factor: The multiple to which you want to round.

Step-by-Step Tutorial

  1. Using MROUND with individual numbers:

    • Example: =MROUND(15, 10)
    • Result: 20

  2. Using MROUND with a calculated value:

    • Example: If cell A1 contains the value 37.5, then =MROUND(A1, 5) will round the value to the nearest multiple of 5, resulting in 40.

Use Cases and Scenarios

  1. Dimension Calculation: Round a length measurement to the nearest inch or centimeter.
  2. Payment Calculation: Determine the nearest dollar or euro amount for a payment.
  3. Time Interval Calculation: Round a duration to the nearest hour or minute.

Related Functions

  • INT: Round a number down to the nearest integer.
  • ROUND: Round a number to a specified number of decimal places.

Related Articles