How to use the Excel CEILING.PRECISE function

The CEILING.PRECISE function is categorized under Excel Math and Trigonometry functions. It will round up a number to the nearest integer or multiple of significance.

As a financial analyst, we can use CEILING.PRECISE in setting the pricing after currency conversion, discounts, etc. When preparing financial models, it helps us round up the numbers per a requirement.

CEILING.PRECISE was introduced in MS Excel 2010 to replace the CEILING function. It was subsequently replaced by the CEILING.MATH function.

Syntax: =CEILING.PRECISE(number, [significance])

The CEILING.PRECISE function syntax has the following arguments:

  • number: The number that you wish to round up.
  • significance: (Optional) It is the multiple of significance that you wish to round a number to.

Example: Let’s look at some Excel CEILING.PRECISE function examples and explore how to use the CEILING.PRECISE function as a worksheet function in Microsoft Excel:

Excel CEILING.PRECISE function - How to use the Excel CEILING.PRECISE function

Syntax: =CEILING.PRECISE(H17,I17)

Result:

Excel CEILING.PRECISE function 2 - How to use the Excel CEILING.PRECISE function

Based on the Excel spreadsheet above, the following CEILING.PRECISE examples would return:

Syntax: =CEILING.PRECISE(H18,I18)
Result: 10

Syntax: =CEILING.PRECISE(H19,I19)
Result: -5

Syntax: =CEILING.PRECISE(H20,I20)
Result: -5

Syntax: =CEILING.PRECISE(H21,I21)
Result: 6.64

Syntax: =CEILING.PRECISE(H22,I22)
Result: 6.64

Syntax: =CEILING.PRECISE(H23,I23)
Result: -6.62

Syntax: =CEILING.PRECISE(H24,I24)
Result: -6.62

Add a Comment

Your email address will not be published. Required fields are marked *