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
Check out the Formula Handbook template!