This article describes the formula syntax and usage of the FLOOR.MATHfunction in Microsoft Excel. Show DescriptionRound a number down to the nearest integer or to the nearest multiple of significance. SyntaxFLOOR.MATH(number, significance, mode) The FLOOR.MATH function syntax has the following arguments.
Remarks
ExampleCopy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data. Formula Description (result) Result =FLOOR.MATH(24.3,5) Rounds 24.3 down to the nearest integer that is a multiple of 5 (20). 20 =FLOOR.MATH(6.7) Rounds 6.7 down to the nearest integer (6). 6 =FLOOR.MATH(-8.1,2) Rounds -8.1 down (away from 0) to the nearest integer that is a multiple of 2 (-10). -10 =FLOOR.MATH(-5.5,2,-1) Rounds -5.5 toward 0 to the nearest integer that is a multiple of 2, using a non-zero Mode, which reverses rounding direction (-4). -4 Top of Page |