FLOOR Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2
Example 3

Rounds a number toward 0 (zero), to the next integer, or to the next instance of multiple.

FLOOR(number, multiple)

Parameters

Name

Required/Optional

Data Type

Description

number

Required

Number

The number to round.

multiple

Required

Number

The multiple to which to round.

Return Value

Number

If multiple is not specified, the number rounds toward 0 to the next integer.

Number and multiple must have the same signs, or a #NUM! error is returned. If either number or multiple cannot be converted to a value, a #VALUE! error is returned. If either number or multiple is 0, the result is 0.

FLOOR(3.7)

Returns 3.

FLOOR(-3.7)

Returns -3.

FLOOR(3.7, 0.5)

Returns 3.5.

Show: