ROUNDDOWN

ROUNDDOWN x rounded towards 0

Synopsis

ROUNDDOWN(x,d)

Arguments

x: number

d: integer, defaults to 0

Description

If d is greater than zero, x is rounded toward 0 to the given number of digits.

If d is zero, x is rounded toward 0 to the next integer.

If d is less than zero, x is rounded toward 0 to the left of the decimal point

Microsoft Excel Compatibility

This function is Excel compatible.

See also

ROUND, ROUNDUP.