ROUNDDOWN ER function
The ROUNDDOWN function returns the specified number as a Real value after it has been rounded down to the specified number of decimal places.
Syntax
ROUNDDOWN (number, decimals)
Arguments
number: Real
A numeric value that must be rounded down.
decimals: Integer
A numeric value that represents the number of decimal places.
Return values
Real
The resulting numeric value.
Usage notes
This function behaves like ROUND, but it always rounds the specified number down (toward zero).
Example 1
ROUNDDOWN (1200.767, 2) rounds down to two decimal places and returns 1200.76.
Example 2
ROUNDDOWN (1700.767, -3) rounds down to the nearest multiple of 1,000 and returns 1000.
Additional resources
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for