FLOOR function

The Klipfolio FLOOR function rounds numbers down to the nearest multiple of significance. 

The syntax for the FLOOR function is:

FLOOR( data , significance )


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.



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

Related links: