ROUNDDOWN
Purpose
- Rounds numbers down to a user-specified number of digits
Example
- Here is a screenshot, for reference:
- As you can see, ROUNDDOWN will always round down, which is in contrast to ROUND, which will round up or down, depending on the number being rounded
Syntax
=ROUNDDOWN(number, num_digits)
Arguments
- number
- This is the number that you want to round down
- This can be a hard-coded number, cell reference, or calculation
- num_digits
- This is the number of digits that you want to round the number (down) to
- This can be a hard-coded number, cell reference, or calculation
- To understand how the num_digits argument works, carefully review the following screenshot:
External Links
