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..
81% OFF online library of tutorials for mastering Google Sheets
FLOOR.MATH()
Description
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.