ROUNDDOWN

The ROUNDDOWN function rounds a number down toward zero to a specified number of decimal places. Unlike standard rounding, the function always reduces the value regardless of the digit that follows. It is commonly used in financial and reporting calculations where conservative estimates or controlled rounding are required.

Syntax

ROUNDDOWN(value, significance)

Arguments

• value: The number to round.

• significance (Optional): The number of decimal places to round to.

Return value

Returns the number rounded down toward zero.

Example

ROUNDDOWN(Total Sales, 2)

In this example, the Rounded Sales measure is created using the ROUNDDOWN function, which rounds the values in Total Sales down toward zero to two decimal places.

Excel equivalent

ROUNDDOWN