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