HomeApplicationOffice information

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.

  1. These are the most basic functions in Excel that you need to understand
  2. How to use ConcateNate function on Excel
  3. How to use AVERAGEIF function in Excel

Instructions for using Round function in Excel

Round function in Excel has syntax = ROUND (number, n) .

Inside:

  1. Number is the number to be rounded.
  2. N is an argument that can be negative or positive.

With argument N we will have a number of different cases.

  1. If N = 0 then we will round to the nearest integer. For example rounding numbers ROUND (9.23.0) = 9
  2. 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, .
  3. 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.

Round function, how to use rounded functions in Excel Picture 1

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.

Round function, how to use rounded functions in Excel Picture 2

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:

  1. How to combine 2 columns Full name in Excel does not lose content
  2. How to use SUMPRODUCT function in Excel
  3. How to combine Sumif and Vlookup functions in Excel

I wish you all success!

4 ★ | 2 Vote
Round function in ExcelExcel calculation function

You should read it

May be interested

  • Instructions on how to use the Dmax function in ExcelInstructions on how to use the Dmax function in Excel
    the dmax function in excel is used to find the maximum value in the data table with conditional depending on the conditions that the user uses.
  • How to use Hlookup function on ExcelHow to use Hlookup function on Excel
    hlookup function basically also has the function syntax and features like vlookup function, which is to help users find data in excel table, with the conditions or given information. here is the guide for using the hlookup function in detail.
  • Instructions for using Index function in ExcelInstructions for using Index function in Excel
    index is a function that returns an array in excel. when using the index function, you get the values ​​in a cell between the column and the row.
  • DATE Function: Converts numbers to a valid date formatDATE Function: Converts numbers to a valid date format
    the date function in excel is a useful and most commonly used function. let's learn how to use the date function in excel with tipsmake.com.com!
  • How to use NORMDIST function in ExcelHow to use NORMDIST function in Excel
    normdist is a function that returns a distribution with a standard deviation and a confirmed average. the normdist function applies in statistics, including hypothesis testing.
  • How to use the LEN function in ExcelHow to use the LEN function in Excel
    the len function in excel is used to measure the length of a certain string of characters, including spaces and correctly return the total character for the user.
  • How to use ISEVEN and ISODD functions in ExcelHow to use ISEVEN and ISODD functions in Excel
    identifying even and odd numbers may be easy in small groups of data, but with large amounts of data it is different. luckily, excel provides two built-in functions, iseven and isodd, to simplify this task.
  • How to add computers to ExcelHow to add computers to Excel
    to perform complex calculations on excel or even change units, we can install computers on excel.
  • MS Excel 2007 - Lesson 6: Calculation in ExcelMS Excel 2007 - Lesson 6: Calculation in Excel
    excel supports many calculation functions, logic functions for calculating, filtering, collating and analyzing data. this is also a feature that makes excel an indispensable tool for office jobs. in this article, tipsmake.com will show you how to use the overview calculation function in excel 2007.
  • Usage of Min and Max functions in ExcelUsage of Min and Max functions in Excel
    min and max functions on excel will use to find the maximum value, the smallest value in the table, or the selected data area.

Office information