The FLOOR MATH FLOORMATH function is a Math formula that rounds a given number down to the nearest multiple of significance. FLOOR in Excel is a Math Trig Function that rounds a number towards zero to the nearest specified multiple of significance. Purpose of Excel FLOORMATH Function To get rounded down the number.
FLOOR works like the MROUND function but unlike MROUND which rounds to the nearest multiple FLOOR always rounds down.
In this post we will guide you to know the usage of Excel FLOORMATH Function in Office 365 with its syntax definition and examples. In mathematics and computer science the floor function is the function that takes as input a real number displaystyle x and gives as output the greatest integer less than or equal to displaystyle x denoted displaystyle operatorname floor x or. This function provides support for rounding negative numbers. FLOOR works like the MROUND function but unlike MROUND which rounds to the nearest multiple FLOOR always rounds down.