- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - ROUNDUP Function
Description
The ROUNDUP function rounds a number up, away from 0 (zero). ROUNDUP is one of the Excel Rounding Functions.
Syntax
ROUNDUP (number, num_digits)
Arguments
| Argument | Description | Required/Optional |
|---|---|---|
| Number | Any real number that you want rounded up. | Required |
| Num_digits | The number of digits to which you want to round number. | Required |
Notes
ROUNDUP behaves like ROUND, except that it always rounds a number up.
If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
If num_digits is 0, then number is rounded up to the nearest integer.
If num_digits is less than 0, then number is rounded up to the left of the decimal point.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements