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.
Excel ROUND Function:
Syntax of the Excel ROUND Function:
- =ROUND(Number, Number Of Decimal Places to Round)
- =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 ROUNDUP Function:
Syntax of the Excel ROUNDUP Function:
- =ROUNDUP(Number, Number Of Decimal Places to Round)
- =ROUNDUP(3.14159, 3) = 3.142
- =ROUNDUP(A1, 2) = The value of A1 rounded up to two decimal places
Excel ROUNDDOWN Function:
- =ROUNDDOWN(Number, Number Of Decimal Places to Round)
- =ROUNDDOWN(3.14159, 3) = 3.141
- =ROUNDDOWN(A1, 2) = The value of A1 rounded down to two decimal places
Download The Example Spreadsheets Here:
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.
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.