- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- SpreadJS Collaboration Server
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
-
Math and Trigonometric Functions
- ABS
- ACOS
- ACOSH
- ACOT
- ACOTH
- AGGREGATE
- ARABIC
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- BASE
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- COMBIN
- COMBINA
- COS
- COSH
- COT
- COTH
- CSC
- CSCH
- DECIMAL
- DEGREES
- EVEN
- EXACT
- EXP
- FACT
- FACTDOUBLE
- FLOOR.MATH
- FLOOR.PRECISE
- GCD
- INT
- ISO.CEILING
- LCM
- LET
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- MUNIT
- ODD
- PI
- POWER
- PRODUCT
- QUOTIENT
- RADIANS
- RAND
- RANDARRAY
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SEC
- SECH
- SEQUENCE
- SERIESSUM
- SIGN
- SIN
- SINH
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- TRUNC
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- RegEx Functions
- Other Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
ROUNDDOWN
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:
Set places to a value greater than zero to round to the specified number of decimal places.
Set places to zero to round to the nearest whole number.
Set places to a value less than zero to round the value left of the decimal to the nearest ten, hundred, etc.
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