FLOOR.PRECISE Function in Excel: Syntax, Examples and Free Practice
FLOOR.PRECISE is an Excel Math & Trig function. Rounds a number down to the nearest multiple, always rounding toward zero.
FLOOR.PRECISE syntax
Arguments
number: A number to use in the calculationsignificance: The multiple to round to (optional)
When to use FLOOR.PRECISE
FLOOR.PRECISE is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice FLOOR.PRECISE online, free
Open the live Excel-style spreadsheet and try FLOOR.PRECISE yourself. No Excel install or sign-up needed to start.
Practice FLOOR.PRECISE now →More Math & Trig functions
Frequently asked questions
What does the FLOOR.PRECISE function do in Excel?
Rounds a number down to the nearest multiple, always rounding toward zero.
What is the syntax of FLOOR.PRECISE in Excel?
The syntax is =FLOOR.PRECISE(number, [significance]). number: A number to use in the calculation; significance: The multiple to round to (optional).
Where can I practice FLOOR.PRECISE online for free?
Open the free live spreadsheet on Cellgrids and try FLOOR.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