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
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!