Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

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 }.