The Excel CEILING.PRECISE function rounds a number up to a given multiple. Unlike the CEILING function, CEILING.MATH defaults to a multiple of 1, and always rounds negative numbers toward zero.
Round a number up to nearest multiple
A rounded number.
=CEILING.PRECISE (number, [significance])
number - The number that should be rounded.
significance - [optional] Multiple to use when rounding. Default is 1.
The Excel CEILING.PRECISE function will round a number up to the nearest integer or given multiple of significance. By default, CEILING.PRECISE rounds to the nearest integer, using a significance of 1. Positive numbers with decimal portions are rounded up away from zero to the next multiple of significance (e.g. 6.3 is rounded to 7) , while negative numbers with decimal portions are rounded toward zero (e.g. -6.3 is rounded to -6).
The Excel EVEN function returns the next even integer after rounding a given number up. The EVEN function always rounds numbers up (away from zero) so positive numbers become larger and negative numbers become smaller (i.e. more negative).
The Excel ODD function returns the next odd integer after rounding a given number up. The ODD function always rounds numbers up (away from zero) so positive numbers become larger and negative numbers become smaller (i.e. more negative).
The Excel INT function returns the integer part of a decimal number by rounding down to the integer. Note the INT function rounds down, so negative numbers become more negative. For example, while INT(10.8) returns 10, INT(-10.8) returns...
The Excel TRUNC function returns a truncated number based on an (optional) number of digits. For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3. The TRUNC function does no rounding, it simply truncates as specified.
Excel Formula Training
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.