WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » ROUND Excel Function

ROUND Excel Function

ROUND in Excel

ROUND Excel function is an inbuilt function in excel which is used to calculate the round number of a given number with the number of digits to be provided as an argument, this formula takes two arguments one which is the number itself and the second argument is the number of digits we want the number to be rounded up to.t.

ROUND Formula in Excel

ROUND Formula

The ROUND Formula in Excel accepts the following parameters and arguments:

Number – The number which has to be rounded.

Num_Digits – The total number of digits to round the number to.

Return Value:  The ROUND function returns a numeric value.

Usage Notes

  1. The ROUND formula in Excel works by rounding the numbers 1-4 down and rounding the numbers 5-9 up.
  2. You can use the ROUND function in excel for rounding numbers to a specified level of precision. ROUND can be used for rounding to the right or left of the decimal point.
  3. If num_digits is greater than 0, the number will be rounded to the specified decimal places to the right of the decimal point. For example, =ROUND (16.55, 1) will round 16.55 to 16.6.
  4. If num_digits is less than 0, the number will be rounded to the left of the decimal point (i.e., to the nearest 10, 100, 1000, and so on). For example, =ROUND (16.55, -1) will round 16.55 to the nearest 10 and return 20 as the return value or result.
  5. If num_digits = 0, the number will be rounded to the nearest integer (no decimal places). For example, =ROUND (16.55, 0) will round 16.55 to 17.

Explanation

The ROUND in excel follows the general math rules for rounding the numbers. In this Round Function, the number to the right of the rounding digit will determine whether the number should be rounded upwards or downwards. The rounding digit is considered to be the least significant digit after the number is rounded, and it also gets changed, which depends on whether the digit that is following it is less or greater than 5.

  • In case the digit to the right of the rounding digit is 0,1,2,3, or 4, the rounding digit will not be changed, and the number will be rounded down.
  • In case the rounding digit is followed by 5,6,7,8 or 9, the rounding digit will be increased by one, and the number will be rounded up.

Consider the following table to understand the above theory more deeply. In this ROUND in Excel example, we are taking the Number 106.864, and the position is cell number A2 in the spreadsheet.

Formula Result Description
=ROUND (A2,2) 106.86 The number in A2 is rounded to 2 decimal places.
=ROUND (A2,1) 106.9 The number is A2 is rounded to 1 decimal place.
=ROUND (A2,0) 107 The number in A2 is rounded to the nearest integer.
=ROUND (A2,-1) 110 The number in A2 is rounded to the nearest multiple of 10.
=ROUND (A2-2) 100 The number in A2 is rounded to the nearest multiple of 100.

How to Open the ROUND Function in Excel?

You can download this ROUND Function Excel Template here – ROUND Function Excel Template
  1. You can simply enter the desired ROUND formula in the required cell to attain a return value on the argument.
  2. You can manually open the ROUND formula in the Excel dialogue box in the spreadsheet and enter the logical values to attain a return value.
  3. From the below spreadsheet, you can see the Formulas Section in the Menu Bar. Under the Formulas section, Click on the Math & Trig.

ROUND

  1. After clicking the Math & Trig option, select ROUND. The ROUND formula in the Excel dialogue box will open, as shown below.

Round 1

  1. Now you can easily put the arguments and attain a return value. Just put the required values on Number and Num_digits, and you will get the return value.

How to Use ROUND Function in Excel with Examples

Let’s look below at some of the examples of the ROUND formula in Excel. These examples will help you in exploring the use of the ROUND function.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

round example 1

Based on the above Excel spreadsheet, let’s consider three examples and see the ROUND function return based on the syntax of the function.

Example #1

When the ROUND formula for Excel written is =ROUND (A1, 0)

Result: 563

You can see the excel spreadsheet below –

ROUND Example 1-1

Example #2

When the ROUND formula for Excel written is =ROUND (A1, 1)

Result: 562.9

Consider the Excel spreadsheet below-

ROUND Example 2

Example #3

When the ROUND formula for Excel written is =ROUND (A2, -1)

Result: 60

Consider the Excel spreadsheet below –

ROUND Example 3

Example #4

When the ROUND formula for Excel is written =ROUND (52.2, -1)

Result: 50

You can consider the excel spreadsheet below –

ROUND Example 4

Example #5

When the ROUND formula for Excel is written =ROUND (-24.57, 1)

Result: -24.7

You can see the excel spreadsheet below –

ROUND Example 5

Other Rounding Functions in Excel

You can also force Excel to always round a number up (away from zero) with the help of the ROUNDUP function. If you want to force Excel to always round a number down (towards zero), use the ROUNDDOWN function in Excel. For specifying the multiple (example 0.5) that Excel is using to round, use the MROUND function in excel.

Things to Remember

  • The ROUND function is used to return a number rounded to a specific number of digits.
  • The ROUND function is a Math & Trig function.
  • The ROUND function works by rounding the numbers 1-4 down and rounding the numbers 5-9 up.
  • You can round a number up (away from zero) with the help of the ROUNDUP function.
  • You can round a number down (towards zero) with the help of the ROUNDDOWN function.

ROUND Excel Function Video

Recommended Articles

This has been a guide to ROUND Function in Excel. Here we discuss the ROUND Formula in excel and how to use Excel ROUND Function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  • VBA ROUNDUP
  • How to use RAND in Excel?
  • Use INDEX Function in Excel
  • Concatenate in Excel
2 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

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

Login

Forgot Password?

WallStreetMojo

Download ROUND Function Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More