FLOOR

Formula Explanation

The FLOOR function rounds a number down to the nearest integer that is less than or equal to the specified number.

Formula Syntax

Enter in the result column: floor(number / column number)

• All parameters can be data columns, using the CODE at the top of each column, for example: AA1.

Usage Example

Round the numbers in column CW2 down to the nearest integer, and write the results into column CW3.

CW3 = floor(CW2)

✉️ Ask TableDI