Beginner
Math
ROUND
Rounds a number to a specified number of digits.
Compatibility: All Excel versions
Syntax
=ROUND(number, num_digits)
Example
=ROUND(A1,2)
When to Use It
Use ROUND to clean up a calculated value to a sensible number of decimal places, e.g. rounding currency to 2 decimals.