Excel ROUND Functions – Round & Round We Go

The Excel ROUND Functions are some of the Excel Formulas that are great to know, when you need to make calculations or lookup values that are buried in your data or simply compare values or format them. So learning which ones to use and how to use them is imperative if you want to bump up your skill level.


Description of the Excel ROUND Functions

The Excel ROUND Function rounds a number to a specified number of digits.

The Excel ROUNDUP Function works like the Excel ROUND Function, except that it rounds the number up, away from zero, even if the following digit is less than a 5.

The Excel ROUNDDOWN Function also works like the Excel ROUND Function, except that it rounds the number down, towards zero, even if the following digit is larger than 5.


Excel ROUND Function:

Syntax of the Excel ROUND Function:

  • =ROUND(Number, Number Of Decimal Places to Round)

Examples:

  • =ROUND(3.14159, 3) = 3.142
  • =ROUND(A1, 2) = The value of A1 with two decimal places
  • =ROUND(4.567, -1) = 0
  • =ROUND(5.567, -1) = 10
  • =ROUND(5.567, -2) = 0
  • =ROUND(50.567, -2) = 100
Excel ROUND Function

Excel ROUNDUP Function:

Syntax of the Excel ROUNDUP Function:

  • =ROUNDUP(Number, Number Of Decimal Places to Round)

Examples:

  • =ROUNDUP(3.14159, 3) = 3.142
  • =ROUNDUP(A1, 2) = The value of A1 rounded up to two decimal places

Unlike the Excel ROUND Function, the Excel ROUNDUP Function will always round the number up as long as the digit being used to determine the rounding action is greater than zero. See below for more examples.


Excel ROUNDDOWN Function:

  • =ROUNDDOWN(Number, Number Of Decimal Places to Round)

Examples:

  • =ROUNDDOWN(3.14159, 3) = 3.141
  • =ROUNDDOWN(A1, 2) = The value of A1 rounded down to two decimal places

Unlike the Excel ROUND Function, the Excel ROUNDDOWN Function will always round the number down as long as the digit being used to determine the rounding action is greater than zero. See below for more examples.

Excel ROUNDUP Function & Excel ROUNDDOWN Function

Download The Example Spreadsheets Here:

The Excel ROUND Function

The Excel ROUNDUP & ROUNDDOWN Functions​


Why use the Excel ROUND Functions?

Some calculations return several digits beyond the decimal point, and more times than not, you just don't need that many. If you do not require absolute precision and want to round the value to the next highest or lowest values, set by the number of digits to round by, then these functions are just the tools you need to get the job done. Experiment and play with them to see what they can do for you.

Conclusion

Although you could round numbers yourself, using the Excel ROUND Functions makes your life and your calculations much easier to deal with. Whether you need to round them normally or force them to round up or down, these are the functions you need!

Share, Comment, Ask a Question or Rip Me a New One!

If you liked this article, please feel free to share it on social media and comment below if you have any suggestions, questions or corrections. Thank you for reading!

P.S. - Remember to sign up to the newsletter email list, so you can catch all of the new posts and learn about upcoming topics, products and/or services​.
Joe Austin
 

Joe Austin is the founder of Potentials Unleashed. He is currently an IT Professional Manager in the Financial Industry and has been using computers since 1978. While mostly self-taught, he is proficient in several computing areas, such as Programming , Web Development, most Microsoft Office programs, Internet Marketing, Spyware / Malware Removal and even 3D Animation & Modeling.

Click Here to Leave a Comment Below 0 comments
%d bloggers like this: