We raised a $20m Series A led by Coatue + Accel! Click here to read the announcement.

Google Sheets

MROUND is a Google Sheets function that rounds a number to a given number of decimal places. To use it, simply enter the number you want to round, followed by the number of decimal places you want it to be rounded to. For example, if you want to round the number 123.456 to two decimal places, you would enter "123.46" into the function.

The syntax of MROUND is as follows:

=MROUND(number,decimals)

The first argument, number, is the number to round. The second argument, decimals, is the number of decimal places to round to.

The MROUND function in Google Sheets rounds a number to the nearest integer. The syntax for the MROUND function is MROUND(number, num_digits), where number is the number you want to round to the nearest integer, and num_digits is the number of decimal places you want to round to. For example, the following formula will round the number 9.5 to the nearest integer, which is 10: MROUND(9.5, 1).

There are a few occasions when you should not use MROUND in Google Sheets. If you are trying to round a number to a certain decimal place, you should use the ROUND function instead. MROUND is also not necessary if you are only rounding numbers up or down. The ROUNDUP and ROUNDDOWN functions will automatically round numbers up or down to the nearest integer.

There are a few similar formulae to MROUND in Google Sheets. One is ROUND(), which will round a number to a specific number of decimal places. Another is CEILING(), which will round a number up to the nearest whole number. Finally, there is FLOOR(), which will round a number down to the nearest whole number.

Get started with Causal today.

Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.

Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.