- Document Solutions for Excel, .NET Edition Overview
- Key Features
- Getting Started
- Features
- Templates
-
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
-
Math and Trigonometry 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
- EXP
- FACT
- FACTDOUBLE
- FLOOR.MATH
- FLOOR.PRECISE
- GCD
- INT
- ISO.CEILING
- LCM
- LET
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- MUNIT
- ODD
- PERCENTOF
- 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
- Text Functions
- Web Functions
- File Operations
- Document Solutions Data Viewer
- API Reference
- Release Notes
ROUNDUP
This function rounds the specified number up to the nearest number, using the specified number of decimal places.
Syntax
ROUNDUP(value, places)
Arguments
This function has these arguments:
Argument | Description |
|---|---|
value | [Required] Any real value that you want rounded up |
places | [Required] The value of digits to which you want to round number |
Remarks
Regardless of the sign of the number specified by the value argument, the number is rounded away from zero.
Examples
ROUNDUP(A3,–2)
ROUNDUP(C4,B2)
ROUNDUP(R1C2, 2)
ROUNDUP(PI(),5) gives the result 3.14160
ROUNDUP(29.2,-2) gives the result 100
ROUNDUP(-1.963,0) gives the result -2