January 19, 2017

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:

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

Categories

Share:

Related Posts

Between the Sheets — Excel podcast episode 45: using the Let function

In partnership with Experts Exchange. Introduced in the 365 editions of Excel, the Let function lets you define variables, their values and calculations that use

Adobe artificial intelligence feature: Generative Recolor

Adobe just introduced the beta of an artificial intelligence feature for Illustrator called Generative Recolor. As the name suggests, it will recolor artwork for you.

Between the Sheets — Excel podcast episode 34: Artificial intelligence tools like ChatGPT in Excel

In partnership with Experts Exchange. Artificial intelligence is causing a major disruption in information technology. In this episode, we test how well three AI tools

Between the Sheets — Excel podcast episode 44: combining the Take and Filter functions

In partnership with Experts Exchange. The Take and Filter functions are both new in the 365 editions of Excel. By combining them in a formula,

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.