Table of Contents
Summary
The Excel ROUNDDOWN function returns a number rounded down to the specified number of digits.
Function
=ROUNDDOWN(number, num_digits)
Arguments (inputs)
number = the number to round, can be a number or a cell reference
num_digits = The number of digits to round the number to. Zero (0) will round to the nearest integer and negative numbers will round to the left of the decimal point.
Return value
The ROUNDDOWN function returns numerical value that is the rounded down value of the number provided.
Example
In the example above the ROUNDDOWN function rounds the prices in column E down to the next lowest integer (0 instructs the ROUNDUP function to round to the integer).
=ROUNDDOWN(E6,0)
The result returned in cell G6 is $261.
