ROUNDDOWN
The ROUNDDOWN function always rounds a number down, toward zero. Use ROUNDDOWN for conservative estimates, like minimizing costs.
Syntax
rounddown(value, significance)Arguments
value - Required. The number to be rounded.
significance - Optional. The number of decimal places to round off.
Example
ROUNDDOWN(Actuals,2) //Rounds the Actuals to 1 decimal place
Last updated
Was this helpful?