MROUND Function in Google Sheets: How to Use It

The MROUND function in Google Sheets is a useful mathematical function that rounds a number to the nearest integer multiple of another number. This tutorial will explain how to use the MROUND function and highlight its differences from the ROUND function.

Purpose of the MROUND Function

The purpose of MROUND is to round a given number (known as “value”) to the nearest integer multiple of another number (called “factor”).

MROUND Function – Syntax and Arguments

Syntax:

MROUND(value, factor)

Arguments:

  • value: The number you want to round.
  • factor: The number to which you want to round the value. Both arguments are required; omitting the factor will result in a #N/A error.

Examples

In the following examples, the formulas round the values in column A (cell range A2:A5) to the nearest integer multiples of the values (factor) in column B (cell range B2:B5).

MROUND function examples in Google Sheets

For example, let’s look at row 5, where the value is 22 (in cell A5) and the factor is 8 (in cell B5).

To find the nearest integer multiple of 8, consider the following multiples:

  • 1 x 8 = 8
  • 2 x 8 =16
  • 3 x 8 = 24

The integer multiples of 8 are 8, 16, and 24. In this case, the nearest integer multiple of 22 (A5) is 24. Thus, the formula in cell C5 returns:

=MROUND(A5, B5)

Result: 24

This example illustrates how the MROUND function works effectively.

Comparing MROUND with ROUND in Google Sheets

Both MROUND and ROUND are mathematical functions in Google Sheets, but their purposes differ significantly.

  • The ROUND function rounds a number to a specified number of decimal places according to standard rounding rules.

Example 1:

=ROUND(22.1254, 2)

Result: 22.13

Example 2:

=ROUND(22.1254, 1)

Result: 22.1

In contrast to ROUND, the MROUND function focuses on rounding to integer multiples rather than decimal places.

Conclusion

Understanding how to use the MROUND function can greatly enhance your data manipulation capabilities in Google Sheets. Whether rounding numbers to meet specific criteria or comparing them to the ROUND function, knowing the distinctions will help you apply these functions effectively in your spreadsheets.

Resources

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Hierarchical Numbering Sequences in Excel

Creating hierarchical numbering sequences in an Excel spreadsheet can significantly improve the way you...

How to Easily Repeat a Sequence of Numbers in Excel

Excel offers multiple ways to accomplish tasks, and the simplicity of each approach depends...

Create a Sequence of Dates at Every Nth Row in Excel (Dynamic Array)

Would you like to create a sequence of dates in every nth row in...

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.