Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Use the ROUND Function in Excel?

How to Use the ROUND Function in Excel?

(Note: This guide on how to round in Excel is suitable for all Excel versions including Office 365)

The Round function in Excel is used to handle irrational numbers or numbers with trailing digits after the decimal point. It is the same concept as in mathematics to adjust the digits of a decimal number to give an approximate value.

When working with large numbers or data, the trailing digits can be a bit intricate. For example, consider the famous number Pi. It is an irrational number with a fractional value of 22/7 and in decimal terms, its value is 3.141592653589793238, and so on. To avoid confusion while calculating and operating with the value, Pi is rounded off to 3.14. 

Rounding off makes the number easy to read and simple to use. 

Note: Round off values only when there isn’t much need for precision. Or, to represent the number as a whole. For example, it is easy to affirm the population of California is approximately 39,000,000 instead of 38,959,247.

In Excel, you will be working around numbers and calculations. If countered with an irrational number, you can use the ROUND function to round up any number to the desired decimal places based on your need.

In this guide, I will show you how to use the ROUND function to round off values.

Table Of Contents
  1. ROUND Function in Excel
  2. How to Round in Excel Using the ROUND Function?
    • Syntax
    • Example
  3. How to use the ROUND Function Based on Numbers and Digits?
    • When the Last Significant Digit Is Greater Than or Equal 5 
    • When the Last Significant Digit Is Greater Than or Equal 5
  4. Closing Thoughts


Related:

The Excel SMALL Function – 3 Best Examples

How to Make An Excel Forecast Sheet in 3 Steps – The Best Guide

How to Use Excel COUNTIFS: The Best Guide

ROUND Function in Excel

In Excel, the ROUND function works similarly to the conventional mathematical concept of rounding off a number.

Rounding off a number depends on the number of places or significant digits.

When the number after the last significant digit is greater than 5, the last significant digit is incremented by 1. When the number after the last significant digit is less than 5, the last significant digit remains the same.

Also, note that if the digit is a positive value, the number is rounded off to the right of the decimal point. If the digit is a negative value, the number is rounded off to the left of the decimal point.

How to Round in Excel Using the ROUND Function?

Step 1.     Enter the number and digit in the cells

Step 2.     Enter the following formula in the cell or formula bar

Syntax

= (ROUND(number,num_digit))

Here, ‘number’ refers to the number to be rounded off, and ‘num_digit’ is the place to the right or left of the decimal point. The num_digit can be a positive value, negative value, or zero.

The (number,num_digit) in the formula represents the cells of the number and digit respectively.

Example

Example - How to Round in Excel
Example – How to Round in Excel?

In this example, the number 3.1415926 is to be rounded to 1 decimal place. The rounded value is 3.1. If the number is 3.1415926 rounded to 2 decimal places, the rounded value would be 3.14.

Also Read:

How to Add Error Bars in Excel? 7 Best Methods

How to Superscript in Excel? (9 Best Methods)

Excel Goal Seek—the Easiest Guide (3 Examples)

How to use the ROUND Function Based on Numbers and Digits?

Based on the value of the number after the last significant digit and the number of digits to be rounded off, there are two cases of three possibilities each.

  • If the number after the last significant digit is greater than or equal to 5
    • If the num_digit is >0
    • If the num_digit is <0
    • If the num_digit = 0
  • If the number after the last significant digit is lesser than 5
    • If the num_digit is >0
    • If the num_digit is <0
    • If the num_digit = 0

When the Last Significant Digit Is Greater Than or Equal 5 

  • Num_digit Greater Than 0

In this case, the rounding works towards the right of the decimal point, and the last significant digit is incremented by 1.

Round Off a Number Based on the Decimal Place
Examples – Round Off a Number

Let us see the second example (Row 4), where the number is 3.575871 and the num_digit is 3. The number to the right of the three decimal places is 8 which is greater than 5. The last significant digit is incremented by 1 and the rounded-off value is 3.576.

  • Num_digit Lesser Than 0

In this case, the rounding works towards the left of the decimal point, and the last significant digit remains the same.

Round Off a Number Based on Negative Decimal Place
Examples – Round Off of a Number Based on a Negative Value

Let us see the second example (Row 4), where the number is 56183.57 and the num_digit is -2. The last two digits to the left of the decimal point are rounded off to zero. Since the second digit to the left of the decimal pointer is greater than 5, the number before the second digit is incremented by 1. The rounded-off value is 56200.

  • Num_digit Equals 0

In this case, the rounding off works towards the left of the decimal point. The number is rounded off to a whole number and the last significant digit to the left of the decimal point is incremented by 1.

Round Off to its Nearest Whole Number
Examples – Round Off a Number to Its Nearest Whole Number

Let us see the second example (Row 3), where the number is 56183 and the num_digit is 0. The number to the right of the decimal point is 5. The number to the left of the decimal is incremented by 1 and the rounded-off value is 56184. The value is returned as a whole number.

When the Last Significant Digit Is Greater Than or Equal 5

  • Num_digit Greater Than 0

In this case, the rounding works towards the right of the decimal point and the last significant digit remains the same.

Round Off a Number Based on the Last Significant Number
Examples – Round Off a Number Based on the Last Significant Number

Let us see the second example (Row 4), where the number is 3.42314 and the num_digit is 2. The number to the right of the two decimal places is 3 which is less than 5. The last significant digit remains the same and the rounded-off value is 3.42.

  • Num_digit Lesser Than 0

In this case, the rounding works towards the left of the decimal point, and the last significant digit to the left of the decimal point remains the same.

Round Off a Number Based on the Last Significant Number and with a Negative Decimal Place
Examples – Round Off a Number Based on the Last Significant Number

Let us see the second example (Row 4), where the number is 56123.57 and the digit is -2. The rounding works towards the left of the decimal point. The last two digits before the decimal point are rounded off to zero. And the third digit to the left of the decimal point stays the same. That is, the rounded-off value is 56100.

  • Num_digit Equals 0

In this case, the rounding off works towards the left of the decimal point. The number is rounded off to a whole number and the last significant digit stays the same

Round Off a Number to its Nearest Whole Number
Examples – Round Off a Number Based on the Last Significant Number

Let us see the second example (Row 3), where the number is 56123.17 and the num_digit is 0. The number to the right of the decimal point is 1. The number to the left of the decimal remains the same and the rounded-off value is 56184. The value is returned as a whole number. 

Suggested Reads:

How to Shade Every Other Row in Excel? (5 Best Methods)

How to Extract an Excel Substring? – 6 Best Methods

How to Split Cells in Excel? 3 Easy Methods

Closing Thoughts

In this guide, you have seen the importance of rounding up values and how to round up values in Excel. 

Use the ROUND function regularly to improve the readability of your spreadsheets.

To find more high-quality guides, visit our free Excel resources section. 

Want to learn more about Excel? Click here to access our advanced Excel courses with in-depth training modules. You can train your entire team in Excel and other business software, for a low one-time monthly fee here.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

Publisher 2013 – How to Create a New Publication

How to Enter Data into a Microsoft Excel 2016 Spreadsheet

How to Backup and Recover Your Spreadsheets in Microsoft Excel 2016

Using the Lasso Tools in Photoshop Elements 10

Using the Mail Merge Wizard in Word 2010

Automate Incoming Email in Outlook 2013

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)