Sunday, 22 July 2012

Excel ROUND Function Syntax and Examples

MS Excel ROUNDING 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


No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts