The Excel Floor.Math function is one of fifteen rounding functions in Excel.A full list, along with comparison tables, is provided on the Excel Rounding Functions page.
The Excel Floor.Math function rounds a supplied number down to a supplied multiple of significance.
In general, positive values are rounded towards zero and negative numbers are rounded away from zero. However, the user can reverse the direction of the rounding for negative numbers.
Note: the Floor.Math function was first introduced in Excel 2013 and so is not available in earlier versions of Excel.
The syntax of the function is:
Where the arguments are:
|number||-||The number that is to be rounded down.|
|[significance]||-||[significance] argument is ignored).(Note that the arithmetic sign of the|
In column B of the following spreadsheet, the Excel Floor.Math function is used to round down the positive and negative numbers 58.55 and -58.55, to different significance values.
The above examples show how:
Further information and examples of the Excel Floor.Math function can be found on the Microsoft Office website.
If you get an error from the Excel Floor.Math function, this is likely to be the #VALUE! error:
|#VALUE!||-||Occurs if any of the supplied arguments are non-numeric.|