ROUNDDOWN Function

Description

The ROUNDOWN function rounds a number down, toward zero. ROUNDDOWN is one of the Excel Rounding Functions.

Syntax

ROUNDDOWN (number, num_digits)

Arguments

Argument Description Required/Optional
Number Any real number that you want rounded down. Required
Num_digits The number of digits to which you want to round number. Required

Notes

  • ROUNDDOWN behaves like ROUND, except that it always rounds a number down.

  • If num_digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places.

  • If num_digits is 0, then number is rounded down to the nearest integer.

  • If num_digits is less than 0, then number is rounded down to the left of the decimal point.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

ROUNDDOWN Function
advanced_excel_math_trigonometric_functions.htm
Advertisements