EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel ROUND Formula in Excel
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

ROUND Formula in Excel

By Madhuri ThakurMadhuri Thakur

Round Formula in Excel

ROUND Formula in Excel (Table of Contents)

  • Introduction to ROUND Formula in Excel
  • How to Use ROUND Formula in Excel?

Introduction to ROUND Formula in Excel

The round function 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 the versions of MS Excel. The Round function in Excel falls under the “Math & Trigonometry” formulas. This function can be used as a worksheet function.

Syntax:

round formula syntax 

Start Your Free Excel Course

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

Arguments:

  • Number: The number that we want to round.
  • No. of digits: 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 number 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.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,725 ratings)

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 the number 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 no 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 rounded to 145 as 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 as 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 of two decimal places. Like 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 as 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 off 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 cell C2 to C6.

round example 5-3

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 upon the number of digits. The rounded numbers are easy to calculate.

Here is an example showing how the rounding of 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 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 are easy to understand and can be easily communicated as well.

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, then go to the number or currency tab and then type in the number of decimal 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 OK Key. You will see the number rounded off as 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 as per the specified number of digits.
  • ROUNDDOWN – This function rounds the number downwards as 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.
  • If the number of digits is less than 0, the number is rounded to a specified number of digits to the left of the decimal point.
  • If the number of digits equals to 0, the number is rounded to the nearest whole number.

Recommended Articles

This is a guide to ROUND Formula in Excel. Here we discuss How to use ROUND Formula in Excel along with 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
Popular Course in this category
MS Excel Training Bundle
  13 Online Courses |  100+ Hours |  Verifiable Certificates |  Lifetime Validity
4.5
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel for HR Training (8 Courses, 10+ Projects)4.8
2 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download ROUND Formula Excel Template

EDUCBA

Download ROUND Formula Excel Template

EDUCBA

डाउनलोड ROUND Formula Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more