Basic Microsoft Excel Functions: ROUNDUP

This article describes the =ROUNDUP formula and how to use it to round-up a set number of decimal places.

Download the accompanying file(s) for this article.

The ROUNDUP function rounds a number up away from zero. The syntax is very simple and works in the same way as the ROUND function discussed in this article

 The ROUNDUP syntax is:



For example

=ROUNDUP(5.2,0) would round-up to 6

=ROUNDUP(7.65326,2) would round-up to 7.66


But instead of manually typing the numbers into the formula you can link the ‘number’ portion of the syntax to a cell reference e.g

=ROUNDUP(A1,0) would round-up the value in cell A1


Or take it a step further.

If you have lots of values that need to be rounded and you may need to change the ‘num_digits’ value, link that portion of the syntax to a control cell e.g

=ROUNDUP(A1,A3) where the ROUNDUP digits value is held in cell A3

There will be a future article discussing control cells.

If you’ve found this article interesting and or useful please share it on social media using the handy share buttons

Subscribe to our mailing list to be the first to know when new articles are published

At Happy Duck we build bespoke business and financial management tools for small, medium and large companies that help them achieve their goals. This makes us happy. Find out more about us and about our services.

More in Excel Basics


Leave a comment

Your e-mail address will not be published. Required fields are marked *