Skip to content
# EXCEL FUNCTION – ROUND

# Excel Function ROUND

**Syntax:**

### Usage Notes

### EXAMPLE 1:- ROUND

### EXAMPLE 2 :-ROUNDUP

## Recommended Articles

## Similar Posts

### EXCEL FUNCTION – COUNTIFS

### EXCEL FUNCTION – WEEKDAY

### EXCEL FUNCTION – MID

### EXCEL FUNCTION – MIN

### EXCEL FUNCTION – LOWER

### EXCEL FUNCTION – ISERROR

=ROUND(number,num_digits)

We can use Round formula in excel. There are different round formulas.

- ROUND
- ROUNDUP
- ROUND DOWN

When there is decimals in figures so it create problems in calculation here we need to use round formula to round off figures which makes calculations easy its limited to specified decimals.

- Increase and decrease the decimal
- ROUND the numbers to nearest 1 decimal place in Excel
- ROUND the numbers to nearest 2 decimal place in Excel
- ROUND the numbers to Whole Number in Excel
- ROUND the numbers to nearest 10 in Excel
- ROUND the numbers to nearest 100 in Excel
- ROUND the numbers to nearest 1000 in Excel
- Excel Function ROUNDUP – Complete guide
- Excel Function ROUNDDOWN

Let us understand all these with few examples given below.

Here we are using ROUND Formula to round figures in excel. Round Formula ask for 2 arguments. 1 is number and num digits.

If we want to round in 1 decimal the formula is =ROUND(D3,1).

If we want to round in 2 decimal the formula is =ROUND(D4,2)

If we want to round nearest to whole number formula is =E5=ROUND(D4,2)

If we want to round to nearest 10 the formula is=ROUND(D6,-1)

If we want to round to nearest 100 the formula is =ROUND(D7,-2)

If we want to round to nearest 1000 the formula is =ROUND(D8,-3).

As shown in below image

Now we will learn ROUNDUP excel formula. ROUNDUP always roundoff the number to next number. In ROUND we are rounding the value to below numbers or down number. Rest everything is same.

If we want to round in 1 decimal the formula is ==ROUNDUP(D3,1).

If we want to round in 2 decimal the formula is =ROUNDUP(D4,2)

If we want to round nearest to whole number formula is =ROUNDUP(D5,0)

If we want to round to nearest 10 the formula is=ROUNDUP(D6,-1)

If we want to round to nearest 100 the formula is =ROUND(D7,-2)

If we want to round to nearest 1000 the formula is =ROUND(D8,-3)

As shown in below image

COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.

WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7

MID function is used for extracting the mid characters from the available string. The output of the function returns the extracted characters in new cell.

MIN function is used to get the smallest number in range or list of values.MIN function has one required i.e. number1 and optional argument i.e. [number2]

LOWER function is used for changing the format of any text or string to LOWER case.

Excel Function ISERROR Microsoft Excel “ISERROR Function” is a Logical Function and it is used to check if cell contains any “ERROR”. “ISERROR Function” is used as a test to validate if cell contains any…