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

ChatGPT now has a desktop app

In addition to using ChatGPT in a web browser, you can now download it as an app on your desktop. There are editions for Windows,

Get in touch