CEILING.PRECISE Function in Excel: Syntax, Examples and Free Practice
CEILING.PRECISE is an Excel Math & Trig function. Rounds a number up to the nearest multiple, always rounding away from zero.
CEILING.PRECISE syntax
Arguments
number: A number to use in the calculationsignificance: The multiple to round to (optional)
When to use CEILING.PRECISE
CEILING.PRECISE is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice CEILING.PRECISE online, free
Open the live Excel-style spreadsheet and try CEILING.PRECISE yourself. No Excel install or sign-up needed to start.
Practice CEILING.PRECISE now →More Math & Trig functions
Frequently asked questions
What does the CEILING.PRECISE function do in Excel?
Rounds a number up to the nearest multiple, always rounding away from zero.
What is the syntax of CEILING.PRECISE in Excel?
The syntax is =CEILING.PRECISE(number, [significance]). number: A number to use in the calculation; significance: The multiple to round to (optional).
Where can I practice CEILING.PRECISE online for free?
Open the free live spreadsheet on Cellgrids and try CEILING.PRECISE yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts