FLOOR function
FLOOR
The Klipfolio FLOOR function rounds numbers down to the nearest multiple of significance.
The syntax for the FLOOR function is:
FLOOR( data , significance )
Parameters
data | The value to round. | number | vector |
significance | The multiple to which you want to round. | number | scalar |
FLOOR examples
Let's look at some FLOOR function examples.
A | |
1 | 2.5 |
2 | -2.5 |
The following examples are based on the above text from an Excel spreadsheet:
FLOOR( A1 , 1 )
-> ["2"]
FLOOR( A2 , -2 )
-> ["-2"]
In the first example, ["2.5"]
is rounded down to ["2"].
In the second example, ["-2.5"]
is rounded down to ["-2"
.