Whole document tree
    

Whole document tree

FLOOR

FLOOR

Name

FLOOR -- 

Description

FLOOR function rounds @x down to the next nearest multiple of @significance. @significance defaults to 1.

This function is Excel compatible.

Examples

FLOOR(0.5) equals 0.

FLOOR(5,2) equals 4.

FLOOR(-5,-2) equals -4.

FLOOR(-5,2) equals #NUM!.

See also

CEIL, ABS, INT.