How to use the ROUND functions in Excel

If you round numbers in Excel using the Increase Decimal or Decrease Decimal buttons on the Home tab of the ribbon bar, Excel still does its calculations on the full number. Those two buttons are only formatting, and the full number can rear its head elsewhere on the sheet. If you want to really round numbers, use the ROUND function. Its syntax is:
=ROUND(number to be rounded, number of decimal points)

You can also force a number to be rounded up or rounded down regardless of its natural value using the ROUNDUP and ROUNDDOWN functions, which use the same syntax. And if you place a minus sign before the second argument, Excel will round to the nearest 10 value. Here are some examples, rounding the formula of =97/13:

Round functions

To learn more formulas and functions in Excel 2016, check out my course.


On Key

Related Posts

Experts Exchange Adobe Expert (me)

Experts Exchange named me as the leading expert for Adobe Creative Suite. Check out my tutorial on the new artificial intelligence features in Photoshop.

Get in touch