Using the Excel CEILING.PRECISE Function
SummaryThe CEILING.PRECISE function rounds a given number up to the nearest integer or user specified level of significance. Regardless of the number's sign, it is always rounded up.
Syntax=CEILING.PRECISE (number, [significance])
The number argument is required in the CEILING.PRECISE function. This is the value that you wish to round up.
Significance is optional and is the user specified multiple that number should be rounded up to. If significance isn't defined, the default value is 1. If significance is entered as 0 the function will return 0.
Usage NotesThe CEILING.PRECISE function is used to round a number up to the nearest integer. The function always rounds the number argument up. When dealing with decimals, positive numbers will round up to the nearest integer and negative numbers will always round up towards zero. For example, 3.1 would round up to 4 and -3.9 would round to -3. If you require control over how negative numbers are rounded, the CEILING.MATH function can be used.
Compared to CEILING
CEILING.PRECISE differs from CEILING in a few ways:
- CEILING.PRECISE always defaults to a multiple of 1 when rounding
- CEILING.PRECISE always rounds negative numbers towards zero
- CEILING.PRECISE does not consider the sign of the significance argument and only uses the absolute value