Round function, how to use rounded functions in Excel
If you often have to calculate the data on Excel, calculating the average result will inevitably be the case that the result is a decimal number with odd numbers after a comma, or a period. Leaving multiple numbers after the comma will make the data sheet difficult to see, difficult to calculate and not professional. Therefore, rounding up in Excel is necessary to make the table more clear.
If you don't know how to use the Round function in Excel or haven't used the Round function yet, follow the following article of Network Administration.
- These are the most basic functions in Excel that you need to understand
- How to use ConcateNate function on Excel
- How to use AVERAGEIF function in Excel
Instructions for using Round function in Excel
Round function in Excel has syntax = ROUND (number, n) .
Inside:
- Number is the number to be rounded.
- N is an argument that can be negative or positive.
With argument N we will have a number of different cases.
- If N = 0 then we will round to the nearest integer. For example rounding numbers ROUND (9.23.0) = 9
- If N> 0, the number will be rounded to the specified decimal place. Such ROUND (21.25464.5) = 21.25. If N = 1 takes 1 odd number, n = 2 takes 2 odd numbers, .
- If N For example: ROUND (23.23434, -1) = 20. If N = -1, rounded up to tens, N = -2 rounded to hundred and N = -3 to thousands .
We will do so with the score table below. Let's round numbers to 2 decimal places.
In the box to enter the rounded score results, we enter the formula = ROUND (C2,2) and press Enter.
In which C2 column is the average of students. 2 is to take only 2 numbers to the right of the decimal point, rounded up to 2 numbers after the comma. In case N
Immediately the result will give the score rounded to the second number after the decimal point. Scroll down to enter the score for students.
With the Round function in Excel, users will be easy to round the data, more neatly the spreadsheet instead of leaving multiple numbers behind the decimal. When rounding, viewers will easily follow the Excel data sheet, which you can also calculate more quickly.
See more:
- How to combine 2 columns Full name in Excel does not lose content
- How to use SUMPRODUCT function in Excel
- How to combine Sumif and Vlookup functions in Excel
I wish you all success!
You should read it
- Round function (rounding) in Excel
- ROUND function in SQL Server
- Instructions on how to use the ROUND function in excel
- How to round time to 30 minutes or 15 minutes in Excel
- Compare ROUND, ROUNDUP and ROUNDDOWN rounding functions in Excel
- Do not round numbers in Excel, turn off rounding in Excel
- The round () function in Python
- ROUNDUP function in Excel - Usage and examples
May be interested
- Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheetsexcel workbook file is a collection of spreadsheet types (can contain from 1 to 255 spreadsheets) such as: data, graphs, macro, . and often related to each other.
- Complete guide to Excel 2016 (Part 10): Use the Find and Replace functionwhen working with a lot of data in excel 2016, you may find it difficult and time-consuming to determine the specific location of the information.
- Complete guide to Excel 2016 (Part 11): Check spelling in the worksheetlet's tipsmake.com refer to the spell check tutorial on excel 2016 worksheet in this article!
- MS Excel - Lesson 4: Working with lines, columns, sheetsin addition to the content of tables in excel, operations with lines, columns and sheets in this program are also important. in this article, tipsmake.com will guide you to simple operation to add or remove lines, columns or sheets in excel tables.
- How to delete, replace or edit links in PDF documents with PDF Link Editormany pdf documents containing urls can be corrupted over time and you want to delete or replace them with active links. please read the following article to learn how to delete and replace links in pdf files.
- Word 2016 Complete Guide (Part 25): How to check and protect Word documentswhen sharing certain word documents, you may not want to include sensitive personal information or don't want others to edit your document file. fortunately, the word 2016 has a built-in feature to help document checks and protections. please follow the article below to see details on how to do it.