It can be used as a worksheet function WS in Excel. Positive numbers with decimal values are rounded down to the nearest integer eg. Purpose of Excel FLOORMATH Function To get rounded down the number.
In simple words the FLOORMATH function rounds down the number to the nearest specified multiple.
However if the mode argument is provided and is non-zero negative numbers are rounded towards zero see cell B5. Positive numbers with decimal values are rounded down to the nearest integer eg. The Excel FLOORMATH function will round a number down to the nearest integer or given multiple of significance. Rounds number down toward zero to the nearest multiple of significance.