# Mround and Round functions

Options
✭✭

Hi,

What is the difference between the MROUND and ROUND functions? Also, I'm facing an issue with the rounding function in Smartsheet, where the result seems to be different from Excel. How can I ensure that the rounding function in Smartsheet gives the same result as in Excel?

Tags:

• ✭✭✭✭✭
Options

MROUND is for mulitples. If you can share what you want to happen, the community might be able to help.

...

• ✭✭✭✭✭
Options

Formula

Description

Result

MROUND(27, 5)

Rounds 27 to the nearest multiple of 5.

25

MROUND(134, 10)

Rounds 134 to the nearest multiple of 10.

130

MROUND(8.6, 0.5)

Rounds 8.6 to the nearest multiple of 0.5.

8.5

MROUND(-22, 6)

Rounds -22 to the nearest multiple of 6 (both number and multiple are negative).

-24

Formula

Result

ROUND(12.12345,0)

12

ROUND(12.12345,1)

12.1

ROUND(12.12345,2)

12.12

ROUND(12.52345,0)

13

...

• ✭✭✭✭✭
Options

MROUND is for mulitples. If you can share what you want to happen, the community might be able to help.

...

• ✭✭
Options

@heyjay I just need to round my numbers to the nearest whole number. can you please provide an example of MROUND vs. ROUND?

• ✭✭✭✭✭
Options

Formula

Description

Result

MROUND(27, 5)

Rounds 27 to the nearest multiple of 5.

25

MROUND(134, 10)

Rounds 134 to the nearest multiple of 10.

130

MROUND(8.6, 0.5)

Rounds 8.6 to the nearest multiple of 0.5.

8.5

MROUND(-22, 6)

Rounds -22 to the nearest multiple of 6 (both number and multiple are negative).

-24

Formula

Result

ROUND(12.12345,0)

12

ROUND(12.12345,1)

12.1

ROUND(12.12345,2)

12.12

ROUND(12.52345,0)

13

...

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!