HomeApplicationOffice informationRound function (rounding) in Excel

Round function (rounding) in Excel

When calculating and processing data with Excel, there will be a lot of calculated figures that are not rounded as you expect such as calculating the average score .

You want to use the rounding function to round up data in Excel to suit your needs. You may know the Round function is a rounding function, but you do not understand the syntax and usage of the Round function.

The following article guides you the Round function syntax and specific examples to help you understand and visualize more.

Description

The Round function in Excel is used to round a number to a specified number of digits. You can specify the number of digits to round.

There are also functions like:

ROUNDUP: always rounding up.

ROUNDDOWN: always rounding down.

MROUND: round a number to a specific multiple.

Syntax

= ROUND (number, num_digits)

Inside:

number: is the number you want to round.

num_digits: is the number of digits you want to round.

Note:

- If num_digits> 0, the number is rounded to the specified number of decimal places. For example: ROUND (23,23434,2) = 23.23

- If num_digits = 0, the number is rounded to the nearest integer. For example: ROUND (23,23434,0) = 23

- If num_digits <0, the number is rounded to the left of the decimal point. For example: ROUND (23,23434, -1) = 20

Example: Given the following table, you round up to 2 decimal places.

Round function (rounding) in Excel Picture 1

Use the Round function : = ROUND (E5,2).

The following results:

Round function (rounding) in Excel Picture 2

The syntax and usage of the Round function is very simple but the function will help you a lot. Good luck!

3.5 ★ | 2 Vote

You should read it

May be interested

  • How to print in ExcelPhoto of How to print in Excel
    article on how to set the parameters before printing and how to print in excel 2010.
  • The SUM function (sums) in ExcelPhoto of The SUM function (sums) in Excel
    sum in excel is essential in calculating and processing your data, so the sum and sumif functions are used a lot by you. but for those of you who are new to excel spreadsheets, you probably don't fully understand these two functions.
  • Numbering in ExcelPhoto of Numbering in Excel
    numbering the data in an excel spreadsheet is very necessary, instead of having to enter the numbers from the beginning to the end, you can do some quick operations to automatically number the order. self for excel spreadsheet.
  • How to add rows and columns in ExcelPhoto of How to add rows and columns in Excel
    how to add rows and columns in excel. the article shows you 3 ways to add rows (rows) or add columns in excel.
  • Create Hyperlink in WordPhoto of Create Hyperlink in Word
    in the process of working with word, surely not less or less you will also need to insert website links, e-mail or links to files in your computer to make the text full and complete.
  • Change the background image and background in WordPhoto of Change the background image and background in Word
    default word editor background is white background, you can compose important documents ... but you can change the background to avoid boredom with word's default background or suitable for documents. there is different content.

Office information