Spread WPF Documentation
ROUNDDOWN
Spread WPF Documentation > Formula Reference > Formula Functions > ROUNDDOWN

Summary

This function rounds the specified number down to the nearest number, using the specified number of decimal places.

Syntax

ROUNDDOWN(value,places)

Arguments

Use the value argument to specify the number to round. Use the places argument to specify the number of decimal places. The places argument has these rules:

Regardless of the sign of the number specified by the value argument, the number is rounded away from zero.

Remarks

The result is always rounded down.

Data Types

Accepts numeric data for both arguments. Returns numeric data.

Examples

ROUNDDOWN(3.2,0) gives the result 3

ROUNDDOWN(D14,3)

ROUNDDOWN(R14C4,10)

ROUNDDOWN(3.14159,3) gives the result 3.141

ROUNDDOWN(-3.14159,1) gives the result -3.1

ROUNDDOWN(31415.92654,-2) gives the result 31400

See Also