Related Topics: | ||
Description: Rounds number down, toward zero, to the nearest multiple of significance.
Syntax: FLOOR(Number, Significance)
Number is the numerical value you want to round.
Significance is the multiple to which you want to round.
Remarks:
Both arguments must be numerical.
Both Number and Significance must have the same sign.
Regardless of the sign of Number, a value is rounded down when adjusted away from zero. If Number is an exact multiple of Significance, no rounding occurs.
Example:
FLOOR(2.5, 1) = 2 [rounds 2.5 down to nearest multiple of 1]
FLOOR(-2.5, -2) = -2 [rounds -2.5 down to nearest multiple of -2]
FLOOR(-2.5, 2) = #NUM! [returns an error, because -2.5 and 2 have different signs]
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.