{"id":796,"date":"2019-04-19T13:31:23","date_gmt":"2019-04-19T10:31:23","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=796"},"modified":"2019-04-19T13:56:19","modified_gmt":"2019-04-19T10:56:19","slug":"the-round-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-round-function\/","title":{"rendered":"The ROUND Function"},"content":{"rendered":"\n

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

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

ROUND<\/strong>(number<\/strong>, digits<\/b><\/span><\/em>) <\/p>number<\/strong><\/b><\/span>: <\/strong>The number you want to round.
digits<\/strong>: The number of digits to which you want to round 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 to the specified number of decimal places.<\/p>\n\n\n\n

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

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

To always round up, use the ROUNDUP <\/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 ROUND function:<\/strong><\/p>\n\n\n\n

Use the appropriate function in the cell E14 to round the contents of the cell E11 to two decimal places.<\/p>\n\n\n\n

\n