 Excel Functions

# Excel FLOOR.MATH Function

The Excel FLOOR.MATH Function rounds down a supplied number to the nearest integer or to the nearest multiple of significance. In MS-Excel this function is categorized under MATH&TRIGNOMETRY functions.

## Purpose of Excel FLOOR.MATH Function

To get rounded down the number. Positive decimal numbers are rounded down to the nearest integer and a negative value is rounded down away from zero.

## Return value

FLOOR.MATH function will return a rounded number.

## Syntax

= FLOOR.MATH(number,[significance],[mode])

## Usage notes

• Positive numbers with decimal portions are rounded down to the nearest integer.
• For example, 5.2 is rounded down to 5, using the default significance (1).
• By default, negative numbers with decimal portions are rounded away from 0 to the nearest integer. For example, -5.6 is rounded to -6.
• By using 0 or a negative number as the Mode argument, you can change the direction of the rounding for negative numbers. For example, rounding -5.4 with a significance of 1 and a mode of -1 rounds toward 0, to -5.
• The significance argument rounds the number down to the nearest integer that is a multiple of the significance specified. The exception is where the number to be rounded is an integer. For example, for a significance of 3, the number is rounded down to the next integer that is a multiple of 3
• If the number divided by a significance of 2 or greater results in a remainder, the result is rounded down.

### Availability

Since 2013 for Windows.

#### Related Posts

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…