Round(Value, Precision)
Value. The number you want to round.
Precision. The number of decimal places, to which the value must be rounded:
If Precision is greater than 0, the number is rounded to the specified number of decimal places to the right of the decimal point.
If Precision is equal to 0, the number is rounded to the nearest integer.
If Precision is equal to 0, the number is rounded to the nearest integer.
NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.
It returns the result of rounding a number to the specified number of decimal places.
| 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 Wizard │ Mathematical Functions │ Ceiling │ Even │ Floor │ Int │ MRound │ Odd │ RoundDown │ RoundUp │ Trunc