ProductSolutionsTemplatesResources

MROUND

Rounds one number to the nearest integer multiple of another. Learn more

Video field
Math

In Google Sheets, the MROUND() function is used to round a given value to the nearest multiple of a specified factor.

The MROUND() function takes two arguments: the value you want to round and the factor to which you want to round.

For example, if you have a value of 23 and you want to round it to the nearest multiple of 5, the MROUND() function will return 25, which is the nearest multiple of 5.

The syntax for using the MROUND() function in Google Sheets is as follows:

=MROUND(value, factor)

Where "value" is the number you want to round, and "factor" is the number to which you want to round.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!