## Sunday, 22 July 2012

### How to Round the Numbers in Excel

Microsoft Excel ROUND Function
ROUND Function Rounds Down or Rounds Up a number to a specific number of decimal places .
It is made up of 2 arguments, the reference to a number and the number of decimal places that reference is to be rounded to.

Syntax:
=ROUND(number,num_digits)

The number argument can be a number, a cell address referring to a cell that holds a number, or a formula which results in a number.

The num_digits argument can be a negative or positive integer (whole number).  If you use a negative number it rounds that number of places to the left of the decimal point.  If you use 0
(zero), it number rounds to the nearest whole number.

Notes:
Decimal Numbers less than 5 get rounded down and the Decimal Numbers that are 5 or Greater get rounded up.

Decimals 1, 2, 3, and 4 get rounded down., 5, 6, 7, 8, and 9 get rounded up.

For example, 123.7211, 123.7221, 123.7231 and 123.7241 get rounded down to 123.72 and 123.7251, 123.7261, 123.7271, 123.7281 and 123.7291 get rounded up to 123.73.

Example:

 NUMBER ROUND RESULT 1234.121 =ROUND(A2,2) 1234.12 1234.122 =ROUND(A3,3) 1234.122 1234.123 =ROUND(A4,2) 1234.12 1234.124 =ROUND(A5,3) 1234.124 1234.125 =ROUND(A6,2) 1234.13 1234.126 =ROUND(A7,3) 1234.126 1234.127 =ROUND(A8,2) 1234.13 1234.128 =ROUND(A9,3) 1234.128

Thanks,TAMATAM