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 Formula in Excel
 

ROUND Formula in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated May 9, 2023

Round Formula in Excel

 

 

Introduction to ROUND Formula in Excel

The ROUND Formula in Excel returns the rounded value of a supplied number to a specified number of decimal places. In simple terms, this function rounds off a number to a given number of digits. This function is present in all versions of MS Excel. The Round function in Excel falls under the “Math & Trigonometry” formulas. This function can be used as a worksheet function.

Watch our Demo Courses and Videos

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

Syntax:

round formula syntax 

Arguments:

  • Number: The number that we want to round.
  • No. of digits: This is the number value. It is the number of digits of the decimal place we want our number to round off.

How to Use ROUND Formula in Excel?

We will learn how to use the function and how this will make the calculation of numbers or currency easier. Here are some examples.

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

Example #1 – Round Off a Number

Here we want to round off a number to 1 digit. So we use the ROUND Formula in cell C2.

round formula excel example 1-1

After using this formula, the answer is shown below.

round formula excel example 1-2

Drag the same formula in cell C2 to cell C7.

round formula excel example 1-3

Here the function will round off the number to one digit to the right of the decimal. The numbers above 5 will be rounded up, and those below 5 will be unchanged.

Example #2 – Finding the Rounded Number

To find out the rounded number when the number of digits is 0. We will use the ROUND Formula in Cell C2.

round formula excel example 2-1

After using this formula, the answer is shown below.

round formula excel example 2-2

Drag the same formula from cell C2 to cell C7.

round formula excel example 2-3

We have some numbers below, and we will see how the number is rounded off when we have 0 as the of digits. The numbers are rounded off to the nearest integer when the number of digits is 0.

As shown above, the number 33.25 is rounded to 33, 144.71 is rounded to 145, and the first digit after the decimal is 7. And so other remaining numbers will be rounded to the nearest whole number.

Example #3 – Using the ROUND Formula

If the number of the digits is 2, the numbers will be rounded off, as shown below. We are using the ROUND Formula in Cell C2.

round formula in excel 3-1

After using this formula, the answer is shown below.

round formula in excel 3-2

We have a table of numbers that we want to round off up to 2 decimal places. Drag the same formula in cell C2 to cell C6.

round formula in excel 3-3

Here the number is rounded to two decimal places. For 12.539 is rounded off to 12.54, and the number 112.465 is rounded off to 112.47 as the last digit after the decimal is 5 or greater than 5, thus rounding off the previous digit.

Example #4 – Rounding Off to Nearest Value

When we have -1 as the number of digits, the number will be rounded off as below. We are using the ROUND Formula in cell C2.

round formula in excel 4-1

After using this formula, the answer is shown below.

round formula in excel 4-2

Drag the same formula from cell C2 to cell C6.

round formula in excel 4-3

The numbers will be rounded to the nearest 10th value when it is a -1 place of decimal. 17.536 is rounded off to 20, 83.893 is rounded off to 80, and so 124. 465, 215.793 and 311.368

They are rounded off to their nearest 10th, respectively.

Example #5 – Rounding the Negative Number

How is the negative number rounded when the number of digits is 1? We will see this in the below table. We are using the ROUND Formula in cell C2.

round example 5-1

After using this formula, the answer is shown below.

round example 5-2

Drag the same formula in cells C2 to C6.

round example 5-3

The rounded numbers are easy to calculate. Here the numbers are rounded off to one place of decimal as it would have been in a positive number. These were some examples of the ROUND function in Excel showing how the number is rounded off depending on the number of digits.

Here is an example showing how rounding numbers works in the calculation.

Example #6 – Calculate Commission Sales

Here we have a sample data table showing sales executives’ sales, and we have to calculate the commission on those sales.

round example 6-1

After using this formula, the answer is shown below.

round formula in excel 6-2

In cell C7, we are using the SUM Formula.

round example 6-2

After using this formula, the answer is shown below.

round example 6-3

In cell C2, we are using the ROUND Formula.

round example 6-4

After using this formula, the answer is shown below.

round example 6-5

round 11

In the above example, the commission is calculated to 2 decimal places. When we rounded the values to 0, the values became rounded and were easy to understand and could be easily communicated.

Example #7 – Rounding off the Numbers by Cell Formatting

We can also round off a number by changing the cell format. You can do this in the below steps:

  • Select a cell containing the number that you want to round off.
  • Press CTRL+1 to open the format cell dialog box, go to the number or currency tab, and then type in the number of decimals you want to see in the decimal box.
  • Click Ok and close the dialog box.

round formula in excel 7-1

Then,

round formula in excel 7-2

Select the decimal places.

round example 7-3

Press the OK Key. You will see the number rounded off below.

round example 7-4

This is also an alternative method for rounding off numbers.

Also there are two other forms of ROUND functions:

  • ROUNDUP – This function rounds the number upward per the specified number of digits.
  • ROUNDDOWN – This function rounds the number downwards per the specified number of digits.

Going through the above examples, you will be able to understand the ROUND function and its uses in Excel. It is a commonly used function in calculations and the presentation of numeric data.

Things to Remember About ROUND Formula in Excel

  • The ROUND function comes under the Math and Trigonometry function.
  • The function rounds off a number as per the number of digits specified.
  • There are some cases where ROUNDUP and ROUNDDOWN functions suit better than the ROUND function.
  • When the number of digits is from 1-4 after the decimal, the ROUND function will round the number down. And when the digit is from 5-9, the function will round up the number.
  • If the number of digits is greater than 0, the number is rounded to a specified number of digits to the right of the decimal point.
  • When the number of digits is less than 0, the number is rounded to a specified number to the left of the decimal point.
  • If the number of digits equals 0, the number is rounded to the nearest whole number.

Recommended Articles

This is a guide to the ROUND Formula in Excel. Here we discuss How to use ROUND Formula in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. ROUND Excel Function
  2. MROUND in Excel
  3. Excel ROUNDUP Function
  4. Excel ROUNDDOWN Function

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 Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download ROUND Formula Excel Template

EDUCBA

डाउनलोड ROUND Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW