This post will guide you how to use** Excel ROUND function** with syntax and examples in Microsoft excel.

Table of Contents

### Description

The Excel ROUND function rounds a number to a specified number of digits. You can use the ROUND function to round to the left or right of the decimal point in Excel.

The ROUND function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function.

The ROUND function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

### Syntax

The syntax of the ROUND function is as below:

=ROUND (number, num_digits)

Where the ROUND function arguments are:

**number**-This is a required argument. Any real number that you wan to round up.**num_digits**– This is a required argument. The number of digits to which numbe you wnat to round up.

**Note:**

- If num_digits argument is greater than 0, then the number is rounded to the specified number of digits. So it will round to the right of the decimal point.
- If num_digits argument is equal to 0, then the number is rounded to the nearest integer.
- If num_digits argument is less than 0, then the number is rounded to the left of the decimal point.
- If you want to round up a number (away from 0), you can use the ROUNDUP function
- If you want to round down a number (toward 0), you can use the ROUNDDOWN function.

### Excel ROUND Function Examples

The below examples will show you how to use Excel ROUND Function to round a given number up or down to a specified number of decimal point.

**1#** to round a number 2.25 to one decimal places, enter the following formula in Cell B1.

=ROUND(2.25,1)

**2#** to round a number 3.249 to one decimal places, enter the following formula in Cell B2.

=ROUND(3.249,1)

**3#** to round a number -5.432 to two decimal places, enter the following formula in Cell B3.

=ROUND(-5.432,2)

**4#** to round a number 25.632 up to one decimal places to the left of the decimal point, enter the following formula in Cell B4.

=ROUND(25.632,-1)

### Related Functions

- Excel ROUNDDOWN function

The Excel ROUNDDOWN function round the number down to the specified number of digits. The syntax of the ROUNDDOWN function is as below:=ROUNDDOWN (number, num_digits)… - Excel ROUNDUP function

The Excel ROUNDUP function rounds the number up to a specified number of decimal places. It will round away from 0.The syntax of the ROUNDUP function is as below**:**=ROUNDUP (number, num_digits)… - Excel CEILING Function

The Excel CEILING function returns a given number rounded up to the nearest multiple of a given number of significance. The syntax of the CEILING function is as below:= CEILING (number, significance)… - Excel CEILING.PRECISE Function

The Excel CEILING.PRECISE function returns a given number rounded up to the nearest multiple of a given number of significance or returns a number that is rounded up to the nearest integer number.The syntax of the CEILING.PRECISE function is as below:=CEILING.PRECISE (number, [significance])…

## Leave a Reply

You must be logged in to post a comment.