ROUNDDOWN function

ROUNDDOWN(number, digitCount?) ROUNDDOWN(number; digitCount?)

number — Number or { Number }

The number to be rounded.

digitCount — Number or { Number } (optional)

The number of decimal places the resulting number should have, if the number is positive. If the number is negative, the number is rounded to the left of the decimal separator. If omitted, it is assumed to be 0, meaning that this function returns an integer.

Returns — Number or { Number }

A rounded number.

Returns a number rounded down to a certain precision. ROUNDDOWN(1.5)ROUNDDOWN(1,5) returns 1.

If the number of digits is not specified, 0 is assumed, which means that this function returns integers (whole numbers).

If the number if digits is positive, the parameter is interpreted as the number of decimal places the number should be rounded down to. ROUNDDOWN(1.49, 1)ROUNDDOWN(1,49; 1) returns 1.4 (one decimal place).

If the number of digits is negative, the number is rounded to the left of the decimal separator. ROUNDDOWN(123456789, -3)ROUNDDOWN(123456789; -3) returns 123456000 and ROUNDDOWN(123456789, -6)ROUNDDOWN(123456789; -6) returns 123000000.

Examples

ROUNDDOWN(1.5)ROUNDDOWN(1,5)

Returns 1.

ROUNDDOWN(1.5, 0)ROUNDDOWN(1,5; 0)

Returns 1.

ROUNDDOWN(1.49, 1)ROUNDDOWN(1,49; 1)

Returns 1.4.

ROUNDDOWN(123456789, -3)ROUNDDOWN(123456789; -3)

Returns 123456000.

ROUNDDOWN(123456789, -6)ROUNDDOWN(123456789; -6)

Returns 123000000.

ROUNDDOWN(1.51, { 0, 1 })ROUNDDOWN(1,51; { 0; 1 })

Returns the array { 1, 1.5 }{ 1; 1,5 }.

{ ROUNDDOWN(1.51, 0), ROUNDDOWN(1.51, 1) }{ ROUNDDOWN(1,51; 0); ROUNDDOWN(1,51; 1) }

Returns the array { 1, 1.5 }{ 1; 1,5 }.