{"id":799,"date":"2019-04-19T13:38:27","date_gmt":"2019-04-19T10:38:27","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=799"},"modified":"2019-04-19T13:57:05","modified_gmt":"2019-04-19T10:57:05","slug":"the-roundup-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-roundup-function\/","title":{"rendered":"The ROUNDUP Function"},"content":{"rendered":"\n

It rounds a number up to a specified number of digits.<\/p>\n\n\n\n

The syntax of the function is the following: <\/p>\n\n\n\n

ROUNDUP<\/strong>(number<\/strong>, digits<\/b><\/span><\/em>) <\/p>number<\/strong><\/b><\/span>: <\/strong>The number you want to round up.
digits<\/strong>: The number of digits to which you want to round up the number<\/strong>.<\/cite><\/blockquote>\n\n\n\n

<\/div>\n\n\n\n

If digits <\/strong>is greater than 0 (zero), then number is rounded up to the specified number of decimal places.<\/p>\n\n\n\n

If digits <\/strong>is 0, the number is rounded up to the nearest integer.<\/p>\n\n\n\n

If digits <\/strong>is less than 0, the number is rounded up to the left of the decimal point.<\/p>\n\n\n\n

If you don’t want to round always up then use the ROUND <\/a><\/strong>function.<\/p>\n\n\n\n

To always round down, use the ROUNDDOWN <\/a><\/strong>function.<\/p>\n\n\n\n

To round a number to a specific multiple, use the MROUND <\/a><\/strong>function.<\/p>\n\n\n\n\n

<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here is an example of how to use the ROUNDUP function:<\/strong><\/p>\n\n\n\n

Display the values of the cell range A1:A20 in the cell range B1:B20 using a rounded up with 2 decimal places.<\/p>\n\n\n\n

\n