Excel - Microsoft Excel Rounddown Function

Description

The Excel Rounddown function rounds a supplied number down towards zero, to a specified number of decimal places. 

The syntax of the function is: 

ROUNDDOWN( number, num_digits ) 

Where the arguments are listed in the following table : 

The above arguments can be supplied to the Rounddown function as either simple numbers, references to cells containing numbers, or as values returned from other functions or formulas. 

Rounddown Function Examples

The following spreadsheet shows the Excel Rounddown function used with different argument values: 

The above examples show how the Rounddown function always rounds down towards zero - ie. a positive number becomes less positive and a negative number becomes less negative.