Otherwise if significance is negative Floorrounds towards zero. In mathematics and computer science the floor function is the function that takes as input a real number x displaystyle x and gives as output the greatest integer less than or equal to x displaystyle x denoted floor x displaystyle operatorname floor x or x displaystyle lfloor xrfloor. If the passed argument is an integer the value will not be rounded.
The syntax of this function is as follows.
This function is used to round a number down to the nearest integer or to the nearest multiple of significance. 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. The multiple to use for rounding is provided as the significance argument. FLOORMATHnumber significance mode The FLOORMATH function syntax has the following arguments.