Mround and Round functions

User251

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?

heyjay

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

heyjay

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

heyjay

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

User251

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

heyjay

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