FLOOR function

Prev Next

​​​​Description

Rounds down a Number to the nearest Integer value.

Syntax

FLOOR(Number to Round Down)

Arguments

Argument

Type

Dimensions

Description

Number to Round Down

(required)

Number

Any Dimensions

Decimal number to round down.

Returns

Type

Dimensions

Number

Dimensions of Number to Round Down

Examples

Formula

Result

Description

FLOOR(2.36)

2

The nearest integer down of 2.36 is 2.

FLOOR(-2.36)

-3

The nearest integer down of -2.36 is -3.

See also

Excel: FLOOR.MATH

Related articles: CEILING

More of a hands-on learner?

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!