If the number is already an exact multiple no rounding occurs and the original number is returned. The multiple to which you want to round. This article describes the formula syntax and usage of the floor function in microsoft excel.
If it is a positive number with decimal values it could be rounded to the nearest integer.
The multiple to which you want to round. How to use the FLOOR function in Excel In this article we will learn about how to use the FLOOR function in Excel. Examples with Positive and Negative Arguments. 67 is rounded down to 6 while negative numbers with decimal values are rounded away from zero eg.