ROUNDDOWN()
Syntax. ROUNDDOWN(number,num_digits)
Definition. This function rounds a number down to the number of digits specified in num_digits.
Arguments
number (required) The real number to be rounded down
num_digits (required) The number of decimal places to which you want to round the number down
Background. Unlike ROUND(), in which numbers less than five round down and greater than or equal to five round up, the ROUNDDOWN() function always rounds a number down. The number is truncated at the position specified in num_digits. If num_digits is a negative value, the number is rounded down to the specified number of digits before the decimal point.
If num_digits is:
Greater than zero, the number is rounded down to the specified number of decimal places. ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
