Var b Mathfloor040. Var d Mathfloor51. FLOOR in Excel Floor function is used for rounding down the decimal number and integer numbers but this function converts the selected numbers to the nearest possible specified numbers to any down value of it.
For positive numbers with negative multiples of significance Excel returns the NUM.
The FLOOR MATH FLOORMATH function is a Math formula that rounds a given number down to the nearest multiple of significance. This article describes the formula syntax and usage of the FLOORMATH function in Microsoft. However once again if you want to round a number down to the nearest integer or to the nearest specified multiple of significance then you can call the FloorMath worksheet function from VBA. If the number is already an exact multiple no rounding occurs and the original number is returned.