It rounds a number down to a specified number of digits.<\/p>\n\n\n\n
The syntax of the function is the following: <\/p>\n\n\n\n
ROUNDDOWN<\/strong>(number<\/strong>, digits<\/b><\/span><\/em>) <\/p>number<\/strong><\/b><\/span>: <\/strong>The number you want to round down.
digits<\/strong>: The number of digits to which you want to round down the number<\/strong>.<\/cite><\/blockquote>\n\n\n\n<\/div>\n\n\n\nIf digits <\/strong>is greater than 0 (zero), then number is rounded down to the specified number of decimal places.<\/p>\n\n\n\n
If digits <\/strong>is 0, the number is rounded down to the nearest integer.<\/p>\n\n\n\n
If digits <\/strong>is less than 0, the number is rounded down to the left of the decimal point.<\/p>\n\n\n\n
If you don’t want to round always down then use the ROUND <\/a><\/strong>function.<\/p>\n\n\n\n
To always round up, use the ROUNDUP <\/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\nClick on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n