Formula Library

ROUND

math

Rounds a number to a specified number of digits.

Syntax

=ROUND(number, num_digits)

Example

Excel
=ROUND(3.14159, 2)

Rounds 3.14159 to 2 decimal places, returning 3.14.

Tips & Notes

  • →Use 0 for whole numbers, negative for tens/hundreds
  • →ROUNDUP always rounds up, ROUNDDOWN always rounds down
  • →MROUND rounds to a multiple

Need a custom ROUND formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.