×

Excel ROUND() Function

Excel ROUND() Function

The ROUND() function in excel rounds the numbers to specified digits.

Syntax

ROUND(Number,num_digits)

Parameter

Number(required)- This parameter represents the number which you want to round up.

num_digits(required)- This parameter represents the number of decimal places to which you want it to round up.

Category

Math & Trig

Returns

This function returns the rounded number value in the cell.

Example 1

Objective: Use ROUND function to reduce the decimal places of the number to its nearest integer value.

Numbers Rounded Formula
45.3976106 45.00  =ROUND(A18,0)
50.6546265 51.00  =ROUND(A19,0)
85.4139093 85.00  =ROUND(A20,0)
33.5893471 34.00  =ROUND(A21,0)

Example 2

Objective: Use ROUND function to reduce the decimal places of the number to its nearest 2 integer value.

Numbers Rounded Formula
45.3976106 45.40  =ROUND(A18,2)
50.6546265 50.65  =ROUND(A19,2)
85.4139093 85.41  =ROUND(A20,2)
33.5893471 33.59  =ROUND(A21,2)

Example 3

Objective: Round the value to the nearest hundredth value.

Numbers Rounded Formula
451.0000000 450.00  =ROUND(A18,-2)
123.4500000 100.00  =ROUND(A19,-2)
356.3200000 400.00  =ROUND(A20,-2)
323.0000000 300.00  =ROUND(A21,-2)

Related Topics

Multiplication in Excel

Multiplication plays a vital role in Mathematics. Usually, the calculations are performed manually and automatically. Manual calculations take time and sometimes leads to error, and it is a challenging process...

5 minutes read.

Excel MATCH () Function

Excel MATCH () Function The MATCH () function in excel locates the position of a lookup value in a row, column, or table and returns the relative position of an item in an array. Syntax MATCH...

2 minutes read.

Excel TIME() Function

Excel TIME() Function The TIME() function in excel returns the serial number of a particular time. Syntax TIME(HOUR, MINUTE, SECOND) Parameter HOUR (required)- This parameter represents the hour for your time. MINUTE (required)- This parameter represents the...

1 minute read.

Dependent Combo box in Excel VBA

Adding the particular dependent box in the created User form with the help of the Microsoft Excel VBA is considered essential and crucial in Microsoft Excel. Here, in this tutorial, we...

7 minutes read.

Reverse List in Excel

What is Reverse list in Excel? Microsoft Excel is widely used for calculation purposes like statistical and analytical for predicting and getting the result. Sometimes for calculation purposes, the user needs...

5 minutes read.

Nearest Multiple in Excel

In Excel, the values in Multiplication can be round up, down and to nearest Multiplication number using Excel default function. This makes the calculation to be performed in an easier...

3 minutes read.

Row Difference in Excel

Microsoft Excel is used for multiple purposes in various organizations. It is a combination of numeric values, alphabets etc. To calculate data, the user organizes the data according to their...

5 minutes read.

Excel MAX() Function

Excel MAX() Function The MAX() function in excel returns the largest or maximum number from a range of cells. It ignores logical values and text. Syntax MAX(Number1,Number2, ...) Parameter Number1(required)- This parameter represents the string for which you...

1 minute read.

How to make use of the Excel Autofit in Excel

In Microsoft Excel, Autofit can be used to adjust and then fix the column and the respective row height to till the maximum limit until and unless it has the...

7 minutes read.

Excel COUNT() Function

Excel COUNT() Function The COUNT() function counts the number of cells in a range that contain numbers. Syntax COUNT([value1], [value [2], ...) Parameter value1(required)- This parameter represents the first cell in the range. value2, …(optional)- It represents the...

1 minute read.

Purpose of Randomize in Excel

Excel spreadsheets are used on a large scale for business and personal usage. It is used to store data, perform multiple calculations, make assumptions based on charts and graphs etc....

7 minutes read.

What is a name box in Excel?

The name box in Microsoft Excel specifies a name for a single cell or a table. The name box is present in the top left corner, left to the formula...

4 minutes read.

Decimals in Excel

Microsoft Excel is widely used for calculation purposes for various applications. The calculation consists of numbers which include whole numbers, decimals, integers etc. To perform quick calculations, the numbers should...

5 minutes read.

Text to Columns

Text to Columns This Excel feature is used to split the cell content name of one cell into multiple columns based on a delimiter, such as a space or a special character or based...

2 minutes read.

Cells and Ranges in Excel

Cells and Ranges Each cell is identified by its cell address, which is a combination of the column and row on which that cell is situated. A group of cells together are called ‘Range’. When...

5 minutes read.

Excel OFFSET () Function

Excel OFFSET () Function The OFFSET() function in excel returns range of cells that is a specified number of rows and columns from an initial specified range. Syntax OFFSET (reference, rows, cols, [height], [width]) Parameter reference(required)-...

2 minutes read.

How to make use of the Wildcard in Excel

In this modern world, it is known that the wildcard characters in Microsoft Excel are considered to be the most essential and unrated features of Microsoft Excel. Besides all these,...

8 minutes read.

Excel Axes

What is Excel Axes? Axes are a horizontal or vertical line containing units of measure. There are two types of axes X and Y axes. X is a horizontal and Y...

3 minutes read.

Excel DAYS() Function

The DAYS() function in excel returns the number of days that exist between two dates. Syntax DAYS (end_date, start_date) Parameter end_date (required)- This parameter represents the end date. start_date (required)- This parameter represents the start date. Category Date...

1 minute read.

Copying formula in Excel

Copy a formula in Excel While working with statistical calculations in Microsoft Excel, the user uses formulas to calculate the mathematical operations. Implementing these formulas manually for each data is a...

3 minutes read.