How To Use Excel ROUND Function – Quick Guide

It can be during simple calculations or it can complex ones, you might want to round off a few numbers.

Excel ROUND Function can help you with that.

If it is that you only want to hide them from displaying, then be cautious of it…Go with formatting option instead of ROUND function.

Let us see how to use it in detail…

1. What is a ROUND Function?
2. What is the Syntax?
3. How to use it with an example?

1. What is a ROUND Function?

ROUND: The ROUND function can be used to round off a number to desired decimals either to the right or left.

  • ROUNDUP: The ROUNDUP function can be used to round up (away from zero).
  • ROUNDDOWN: The ROUNDDOWN function can be used to round up (towards zero).
  • MROUND: The MROUND function can be used to round a number to a given nearest multiple.

2. What is the Syntax?

=ROUND(Number, No of Digits)

  • Number   =  A number, which you want to round.
  • No of Digits  =  The no of digits to which you want to round the number supplied.

Note :

  • If No of Digits is greater than 0, then the number is rounded to the right of the decimal point.
  • If No of Digits is less than 0, then the number is rounded to the left of the decimal point.
  • If No of Digits is equal to 0, then the number is rounded to the nearest integer.

3. How to use it with an example?

Assuming we have a set of percentage, let’s quickly look at the functionality…!!!

Find the examples for the below:

1. ROUND
2. ROUNDUP
3. ROUNDDOWN
4.MROUND


***ROUND***

 

1. Round a number to two decimal places

Round2

2. Round a number to one decimal place

Round1

3. Round a number to the nearest integer

Round0

4. Round a number to the nearest 10

Round -1

5. Round a number to the nearest 100

Round -2


***ROUNDUP***

 

RoundUp


***ROUNDDOWN***

 

RoundDown


***MROUND***

 

Mround

 

Hope it has helped you…

Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply