The ROUNDDOWN function rounds down a number to a specified number of digits. In this guide, we’re going to show you how to use the ROUNDDOWN function and also throw in some tips and error handling methods.
Supported versions
- All versions
Syntax
ROUNDDOWN(number,[num_digits])
Arguments
number |
The number to be rounded. |
[num_digits] |
The number of digits. |
Examples
Firstly a reminder: Named ranges are added to ease of reading formulas.
Example 1
=ROUNDDOWN(314.159265358979,2)
Example 2
=ROUNDDOWN(314.159265358979,0)
Example 3
=ROUNDDOWN(314.159265358979,-2)