How to Round Down

[JBO]

I need to round down my data to whole numbers.

1.56 = 1

1.43 = 1

2.78 = 2

3.01 = 3

Any help much appreciated.

[MarqueeCrew · Accepted solution]

FLOOR(x)
Returns largest integer less than or equal to (x)

OpenExample

FLOOR(1.1) returns 1
FLOOR(6.54) returns 6
FLOOR(-30.42) returns -31


Cheers,

Mark

[JBO]

Thank you so much! And thank you for getting back to me so quickly. You saved me from having to do a lot of extra work. Cheers!