Mround and Round functions

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?
Best Answers
-
MROUND is for mulitples. If you can share what you want to happen, the community might be able to help.
...
-
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
...
Answers
-
MROUND is for mulitples. If you can share what you want to happen, the community might be able to help.
...
-
@heyjay I just need to round my numbers to the nearest whole number. can you please provide an example of MROUND vs. ROUND?
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!