Search

# How to Use Excel ROUND Function (Examples + Video)

## Excel ROUND Function (Example + Video)

### When to use Excel ROUND Function

ROUND function can be used when you want to returnÂ a number rounded to a specified number of digits.

### What it Returns

A number rounded to a specified number of digits.

### Syntax

=ROUND(number, num_diguts).

### Input Arguments

• number – the number that you want to round.
• num_digits –Â the number of digits to which you want to round the number argument.

• If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
• For example, =ROUND(500.51,1) would return 500.5.
• If num_digits is 0, the number is rounded to the nearest integer.
• For example, =ROUND(500.51,0) would return 501.
• If num_digits is less than 0, the number is rounded to the left of the decimal point.
• For example, =ROUND(500.51,-1) would return 501.

## Excel ROUND Function – Video Tutorial

Related Excel Functions:

Other Useful Excel tutorials:

FREE EXCEL BOOK

## Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

### 2 thoughts on “How to Use Excel ROUND Function (Examples + Video)”

1. Thanks well explained.

• Thanks for commenting Gopala.. Glad you liked it ðŸ™‚

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster