ROUND
Rounds a number to a specified number of digits.
Math & TrigonometryBeginner EssentialsMath BasicsMost Used
What it does
Rounds a number to a specified number of digits.
Syntax
ROUND(number, num_digits)
Arguments
number(number) — Number to round.
Examples
Round to 2 decimals
Round A2 to 2 decimal places.
FORMULA
=ROUND(A2,2)
RESULT
3.14
SAMPLE DATA
| A | |
|---|---|
| 1 | Number |
| 2 | 3.14159 |
| 3 | 2.71828 |