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)