The function instead of accepting 2 arguments as Excel, accepts only 1 argument and returns the nearest integer less than or equal to the number.
= FLOOR(value)
Value |
A number whose floor value is to be calculated. The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
Decimal number.
In the case of an error, the function displays an error message: “FLOOR(value): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= FLOOR(1.789) |
1 |
= FLOOR(-2.789) |
-3 |
= FLOOR(“100.83%”) |
1 |
= FLOOR(UnitPrice) |
The floor value of the UnitPrice |
= FLOOR(“abcd”) |
Displays message “FLOOR(abcd): Input string was not in a correct format.” |
= POWER(FLOOR(UnitPrice), 2) |
The square of the floor value of UnitPrice |
= MAX(FLOOR(UnitPrice), 12) |
The maximum among the floor value of UnitPrice and 12. |