Aug 04, 2016
When you work with numbers in Microsoft Excel you will often come across decimal numbers which need to be rounded off. Luckily, there are a variety of formulas to use to round numbers, such as, ROUND, ROUNDUP, ROUNDDOWN, CEILING and a few more.
Read on to know how to use all these functions and how to round numbers based on any criteria.
Apr 22, 2021
There are times where, despite its precision, you'd like Excel to do a little work for you in terms of reducing precision. There are three functions used to round [...]
Aug 27, 2020
The first thing I’d like to point out about rounding numbers in Excel is that simply hiding decimal places isn’t true rounding; the decimal places are still there, just [...]
Sep 04, 2020
In Part 1 of this series I discussed the worksheet functions ROUND, ROUNDUP and ROUNDDOWN. They will truly round numbers to a certain number of decimal places. But what [...]
How do your Excel skills stack up?
Test NowRelated Articles
About the Author:
New Horizons
New Horizons is Australia's leading corporate training provider, and has been educating business professionals for over 15 years in the areas of Professional Development, Microsoft Office & Adobe Applications, and IT Technical. Our aim through this blog is to bring you relevant stories, articles, and tips & tricks that can help you to improve your skills and productivity in the workplace. Our expert trainers will also be posting their own articles from time to time, so be sure to keep an eye out.
Read full bio
Next up:
- Create and use workflow templates in SharePoint Designer 2013
- Is your email inbox overloaded? Use these clever tips to manage it.
- Automation control at your fingertips
- The four skill levels of facilitation
- Don’t risk your confidential data – protect it with symmetric encryption
- How-to: chart an equation in Excel VBA without producing a table
- Common sense is not so common
- Excel Shortcuts you will thank us for
- How-to: Open an Excel workbook containing macros, without running the macros
- Secure and sync in OneDrive for Business
Previously
- Create and use workflow templates in SharePoint Designer 2013
- 3 punctuation marks you might be using incorrectly
- Ready, set, goals
- 4 guides to help you become a PowerPoint pro
- Easy customisations in Word 2013
- Quick Tuts: PowerPoint 2010 - Animating SmartArt Graphics
- Quick Tuts: Excel 2010 - vLookups simplified
- Social tagging in SharePoint 2010
- Tailoring your document with Styles
- Create with Adobe’s Capture Mobile app: Creating Brushes
