ROUNDDOWN function
Summary
Rounds a number down, toward zero
Syntax
ROUNDDOWN(number, num_digits)
The ROUNDDOWN function syntax has the following arguments:
• Number Required. Any real number that you want rounded down.
• Num_digits Required. The number of digits to which you want to round number.
• Number Required. Any real number that you want rounded down.
• Num_digits Required. The number of digits to which you want to round number.
Example
=ROUNDDOWN(3.2, 0)
=ROUNDDOWN(76.9,0)
=ROUNDDOWN(3.14159, 3)
=ROUNDDOWN(-3.14159, 1)
=ROUNDDOWN(31415.92654, -2)
=ROUNDDOWN(76.9,0)
=ROUNDDOWN(3.14159, 3)
=ROUNDDOWN(-3.14159, 1)
=ROUNDDOWN(31415.92654, -2)