RoundDown

Syntax

RoundDown: Regular report (Value, Precision)

Parameters

Value. Real value that should be rounded down.

Precision. The number of decimal places, to which the value must be rounded:

NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.

Description

It returns the result of rounding the number to the nearest value smaller in modulus.

Example

Formula Result Description
=RoundDown(124.658, 2) 124,65 It rounds down the 124.658 number to two decimal places to the right of the decimal point.
=RoundDown(B6,0) 124 It rounds the number in the B6 cell down to the nearest integer. The B6 cell contains the 124.658 number.
=RoundDown(B6, C6) 100 It rounds the number from the B6 cell down to the number of digits specified in the C6 cell. The B6 cell contains the 124.658 number, and C6 contains -2.

See also:

Function WizardMathematical FunctionsCeilingEvenFloorIntMRoundOddRoundRoundUpTrunc