- 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
Compatibility - CEILING Function
Description
The CEILING function returns a number rounded up, away from zero, to the nearest multiple of significance.
Syntax
CEILING (number, significance)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Number | The value you want to round. | Required |
Significance | The multiple to which Number is to be rounded. | Required |
Notes
Regardless of the sign of number, a value is rounded up when adjusted away from zero. If the number is an exact multiple of significance, no rounding occurs.
If the number is negative, and significance is negative, the value is rounded down, away from zero.
If the number is negative, and significance is positive, the value is rounded up towards zero.
If either argument is nonnumeric, CEILING returns the #VALUE! error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016.
Example
advanced_excel_compatibility_functions.htm
Advertisements