The ROUNDDOWN Function will round a supplied number down towards zero, to a specified number of decimal places.
The ROUNDDOWN function is an inbuilt function in Excel under the category of Math/Trig Function. You can enter the ROUNDDOWN function as part of a formula in a cell of a worksheet.
Syntax for ROUNDDOWN Function
=ROUNDDOWN( number, num_digits )
Number – The number to round down.
Digits – The number of digits to round the number down to.
I have created the infographics for the ROUNDDOWN Function. With the help of these infographics, you can easily learn step by step process for using this excel functions.
Furthermore, Excel consists of many inbuilt functions which are helpful in the analytical and statistical study of number.
Simply follow the instructions in the infographics below:
If num_digits is greater than 0 (zero), then the number is rounded down to the specified number of decimal places.
If the specified num_digits is 0, then the number is rounded down to the nearest integer. But if num_digits is less than 0, then the number is rounded down to the left of the decimal point.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.