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.

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Now certified in AI Ethics

Just earned my third AI certification: AI+ Ethics, from AI Certs. Now offering training in ethics issues, including transparency, accountability, privacy, mitigating bias and compliance

Earned another AI certification

I just earned the AI+ Executive certification from AI Certs. This is to assist and train companies in developing AI strategies, governance and risk management,

Get in touch

AI Workshop Inquiry/Booking