EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Maths Function in Excel ROUND Function in Excel
 

ROUND Function in Excel

Madhuri Thakur
Article byMadhuri Thakur

ROUND Function in Excel

ROUND in Excel

The round function in Excel is used to round off the decimal values used for both roundings off the decimal numbers irrespective of the number of digits they have after the decimal and for choosing to what limit we want to see the numbers after the decimal. For this, select the decimal number we want to round off, then choose the number of digits after the decimal.

 

 

ROUND Formula in Excel

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Below is the ROUND Formula in Excel :

ROUND Formula in Excel

The ROUND Function has the following arguments:

  • Number – The number which needs to be round.
  • Num-digits – The number of digits to which the given number should be rounded.

As ROUND Function is part of the Math & Trig Function, it is under the ‘Formulas’ tab. Please follow the below step:

  • Click on the Formulas tab.

Step 1

  • Select Math & Trig Option.

Step 2

  • Select the ROUND Function from the above drop-down menu list.

Step 3

  • After clicking on ROUND Function, it will open a pop-up for function arguments:

Step 4

  • Under the number field, enter a number that needs to be round.

Step 5

  • Under the num_digit field, enter the number of digits to which you want to round.

Step 6

How to Use the ROUND Function in Excel?

The ROUND Function in Excel is very simple and easy to use. Let us understand the working of the ROUND Function in Excel by some ROUND Formula examples.

You can download this ROUND Function Excel Template here – ROUND Function Excel Template

Example #1

From the below-given data, extract the round values.

Example 1

So the result will be:

ROUND Example 1-2

Similarly, we find other values by using the ROUND Function.

ROUND Example 1-3

Example #2

From the below-given data, extract the round values.

Example 2

So the result will be:

ROUND Example 2-2

We can drag the formula by using Ctrl + D or double click on the right corner of cell C15. So the result would be:

ROUND Example 2-3

Explanation:

  • If you want to round a number to the nearest 1000, we use ROUND Function and pass -3 in the place of the second argument.
  • For rounding a number to the nearest 100, pass -2 in place of the second argument.
  • For rounding a number to the nearest 10, pass -1 in place of the second argument.

If you want to round a number in a simpler way, you can use the ROUND Function with the specified number of digits.

Example #3

From the below-given data, extract the round values.

Example 3

So the result will be:

ROUND Example 3-2

We can drag the formula by using Ctrl + D or double click on the right corner of the cell C27. So the result would be:

ROUND Example 3-3

Example #4

From the below-given data, extract the round values.

Example 4

So the result will be:

ROUND Example 4-2

We can drag the formula by using Ctrl + D or double click on the right corner of cell C38. So the result would be:

ROUND Example 4-3

Things to Remember

  • Round Function rounds a number 1-4 down and 5-9 up by rounding numbers.
  • This Function rounds numbers to a specified level of precision. It rounds to the left or left of the decimal point.
  • If the second argument num_digits is greater than 0, then the given number is rounded to the right of the decimal point.
  • When the the second argument num_digits less than 0, the given number is rounded to the left of the decimal point.
  • If num_digits = 0, a number is rounded to the nearest integer.
  • Always round up away from Zero; use the ROUNDUP Function.
  • To always round down towards Zero, use ROUNDDOWN Function.
  • To round a number to a specific multiple of a digit, use the MROUND Function.

Recommended Articles

This has been a guide to ROUND Function in Excel. Here we discuss the ROUND Formula in Excel and how to use the ROUND Function in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. IFERROR Formula in Excel
  2. Excel ROUNDDOWN Function
  3. Excel Rounding
  4. VBA Round

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download ROUND Function Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download ROUND Function Excel Template

EDUCBA

डाउनलोड ROUND Function Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW