81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode..

How To Use in Sheets

FLOOR.MATH(number, [significance], [mode])

External Links

Floor.math function example in excel

This video shows you how to rounds a value down using floor.math formula in MS Excel 2019 Office 365.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.