Rounding up to the nearest even number
Hi. How can I round up the result of a formula to the nearest even number? IOW, how can I convert the EVEN function in excel to Smartsheet?
Best Answers
-
The ROUND, ROUNDDOWN, ROUNDUP, and MROUND functions handle rounding in Smartsheet.
If you always want to round UP to nearest EVEN number, then you would use something like this:
=MROUND(ROUNDUP(NumberColumn@row), 2)
With this formula, 356.23 becomes 358, because you're rounding the 356.23 UP to 357, and then using MROUND to round up to the nearest multiple of 2.
You can find all these functions on this reference page:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Happy to help! If you could mark my answer as Accepted, that would be great.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
The ROUND, ROUNDDOWN, ROUNDUP, and MROUND functions handle rounding in Smartsheet.
If you always want to round UP to nearest EVEN number, then you would use something like this:
=MROUND(ROUNDUP(NumberColumn@row), 2)
With this formula, 356.23 becomes 358, because you're rounding the 356.23 UP to 357, and then using MROUND to round up to the nearest multiple of 2.
You can find all these functions on this reference page:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you so much! That was very helpful ..it worked! Thanks again.
-
Happy to help! If you could mark my answer as Accepted, that would be great.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!