Round

Syntax

Round(Value, Precision)

Parameters

Value. The number you want to round.

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 a number to the specified number of decimal places.

Example

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

See also:

Function WizardMathematical FunctionsCeilingEvenFloorIntMRoundOddRoundDownRoundUpTrunc