FLOOR

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.

Syntax

= FLOOR(value)

Parameters

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).

Return Type

Decimal number.

In the case of an error, the function displays an error message: “FLOOR(value): Error message”

Examples

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.