[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

FLOOR

Syntax:

FLOOR ( x , significance )

Description: Computes x rounded down, toward zero, to the nearest multiple of significance. Regardless of the sign of x, a value is rounded down when adjusted away from zero.

Arguments:

Name

Type

Description

x

number

The value to be rounded,

significance

number

The multiple to which x is to be rounded.

 

Return Type and Value: number – The rounded-down value of x.

However, if x and significance have different signs, #NUM! is returned.

[Example:

FLOOR(2.5,1) rounds 2.5 down to nearest multiple of 1; that is, to 2
FLOOR(-2.5,-2) rounds -2.5 down to nearest multiple of -2; that is, to -2
FLOOR(1.5,0.1) rounds 1.5 down to the nearest multiple of 0.1; that is, to 1.5
FLOOR(0.234,0.01) rounds 0.234 down to the nearest multiple of 0.01; that is, to 0.23

end example]