Round numbers with Round Function

image_pdf

It is necessary to use proper Number format while working with Numbers in Excel. We can increase and Decrease decimal places without changing the Number. Check here article about How to use proper Decimal places using Number Format in Excel. We can also use ROUND function for the same.

How to use ROUND functions in excel?

The ROUND function rounds the given number up to specified decimal places.

Syntax:

               =ROUND( number, num_digits )

number: The given  number.

num_digits: The number of decimal places to round to.

Note:

positive num_digits: value means rounding the digits to right of decimal point.

num_digits value of 0 means rounding to nearest integer.

negative num_digits means rounding the digits to left of decimal point.

Example:

round

round1roundup1

How to use ROUNDDOWN function?

The ROUNDDOWN function rounds the number  to zero to a specified number of decimal places.

Syntax:

               =ROUNDDOWN( number, num_digits )

Example:

rounddown

rounddown1

rounddown2

How to use ROUNDUP function?

The ROUNDUP function rounds the number away from zero to a specified number of decimal places.

Syntax:

               =ROUNDUP( number, num_digits )

Example:

roundup

roundup2

Explore more, It's Amazing…

How to Enter Fractions in Excel?

Difference between Currency Format and Accounting Format

 

 

 

 

 

 

 

5,392 total views, 7 views today

One thought on “Round numbers with Round Function

  1. I like the new report lyaout as it simplifies the functionality. Very good!BUT: I really need to be able to sort the time entries by project in the Detailed report. I suggest that you change the text in the current column Description to Description / Project (as this column shows both) and makes the text Project to a link, that will sort the entries by project. Very easy And another issue. If you in the Summary report filter the entries by on or more users, and then click on an entry then the selection of users is not transfered to the view in the Detailed report. As a consequence I get more time entries (from other users also) than I would expect from the entries in the Summary report. So you just need to transfer the filtering of users when you do a link from the Summary Report to the Detailed report. Also very easy

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>