The FLOOR MATH FLOORMATH function is a Math formula that rounds a given number down to the nearest multiple of significance. -58 is rounded to -6. In column B of the following spreadsheet the Excel Floor function is used to round the positive and negative numbers 2675 and -2675 to different multiples of significance.
The FLOOR function is a built-in function in Excel that is categorized as a MathTrig Function.
If the spreadsheet is exported to Microsoft Excel the FLOOR function is exported as the equivalent FLOORMATH function that has existed since Excel 2013. FLOOR in Excel is a Math Trig Function that rounds a number towards zero to the nearest specified multiple of significance. If the number is already an exact multiple no rounding occurs and the original number is returned. FLOORMATH Function is used to round a given number to a specified multiple.