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 yet. Stay tuned!