Skip to main content
FLOOR

Rounds a number down to the nearest integer

Updated over a year ago

Description

The FLOOR() function rounds a given number down to the nearest whole number or integer, effectively moving it towards negative infinity if positive, or closer to the next negative integer if negative

Syntax

FLOOR(number)

Output

integer

Variables

  1. number: The numeric value you want to round down to the nearest integer.

Example

FLOOR(`Price (USD)`)

Product

Price (USD)

Quantity Sold

FLOOR

Product A

25.99

150.00

25

Product B

14.75

280.00

14

Product C

7.99

500.00

7

Product D

35.20

90.00

35

Product E

50.00

120.00

50

Did this answer your question?