Skip to main content

​​​​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!

 

 

Be the first to reply!