Excel Function : ROUNDDOWN
Category
Math and trigonometry
Description
Rounds a number down, toward zero
Microsoft Excel Reference Page
https://support.office.com/en-us/article/ROUNDDOWN-function-2ec94c73-241f-4b01-8c6f-17e6d7968f53
Syntax and Description of the ROUNDDOWN Excel Function
The Excel ROUNDDOWN function rounds a number down to a given number of digits. =ROUNDDOWN(number, num_digits) The function takes two arguments: number: The number to round. num_digits: The number of digits to round to.
About ROUNDDOWN Excel Function
ROUNDDOWN rounds a number down, toward zero, to the specified number of decimals. Syntax: =ROUNDDOWN(number, num_digits) Arguments number - The number you want to round. num_digits - [optional] The number of digits to which you want to round. Negative num_digits rounds to the left of the decimal point; zero num_digits rounds to the nearest integer.