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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
