Excel Function : CEILING.PRECISE

Download now!

Excel Function : CEILING.PRECISE

Category

Math and trigonometry

Description

Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.

Microsoft Excel Reference Page

https://support.office.com/en-us/article/CEILINGPRECISE-function-f366a774-527a-4c92-ba49-af0a196e66cb

Syntax and Description of the CEILING.PRECISE Excel Function

error I am getting error while using the CEILING.PRECISE function in excel. It is giving me syntax error, while I am using the function according to the syntax as mentioned in the microsoft office website. A: CEILING.PRECISE is available in Office 365 only. If you are using Office 365, check if you have the latest version and then try using the function.

About CEILING.PRECISE Excel Function

CEILING.PRECISE rounds a number up to the nearest number with a specific precision. For example, if precision is set to 2, then CEILING.PRECISE will round up to the nearest 100th.