Compatibility - FLOOR Function

Description

The FLOOR function rounds number down, toward zero, to the nearest multiple of significance.

Syntax

FLOOR (number, significance)

Arguments

Argument Description Required/Optional
Number The numeric value you want to round. Required
Significance The multiple to which you want to round. Required

Notes

  • If the sign of number is positive, a value is rounded down and adjusted toward zero.

  • If the sign of number is negative, a value is rounded down and adjusted away from zero.

  • If number is an exact multiple of significance, no rounding occurs.

  • If either of the arguments is nonnumeric, FLOOR returns the #VALUE! error value.

  • If number is positive and significance is negative, FLOOR returns the #NUM! error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

FLOOR Function
advanced_excel_compatibility_functions.htm
Advertisements