# Rounding up to the nearest even number

Options
✭✭

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?

Tags:

• ✭✭✭✭✭✭
Options

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

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭
Options

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

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭
Options

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

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!