ROUNDDOWN

Rounds down a given number to a specified number of digits.

Sample Usage

ROUNDDOWN(15.55)
ROUNDDOWN(15.55, 1)
ROUNDDOWN(C5)

Syntax

ROUNDDOWN(number, [count])

  • number - The number to be rounded.
  • count - [OPTIONAL] The number of places to which the number is to be rounded.

Examples

ROUNDDOWN(15.55) returns the number 15
ROUNDDOWN(15.55, 1) returns the number 15.5

 Notes

  • ROUNDDOWN behaves like ROUND, except that it always rounds a number down.
  • If count is greater than 0 (zero), then number is rounded down to the specified number of decimal places.
  • If count is 0, the number is rounded down to the nearest integer.
  • If count is less than 0, the number is rounded down to the left of the decimal point.