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