Rounding up to the nearest even number

User251

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?

Jeff Reisman

@User251

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:

Functions List | Smartsheet Learning Center

Jeff Reisman

https://community.smartsheet.com/discussion/comment/321564#Comment_321564

Happy to help! If you could mark my answer as Accepted, that would be great.

Jeff Reisman

@User251

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:

Functions List | Smartsheet Learning Center

User251

Thank you so much! That was very helpful ..it worked! Thanks again.

Jeff Reisman

https://community.smartsheet.com/discussion/comment/321564#Comment_321564

Happy to help! If you could mark my answer as Accepted, that would be great.