Round Cell Values

Excel has several functions that you can use to round off worksheet values.

 

ROUND function

1.   ROUND function rounds a number to a specific number of digits

2.   General syntax: ROUND(number,num_digits)

  • number: the number you want to round
  • num_digits:the number of digits to which you want to round the number
    • If num_digits is greater than 0 (zero), number is rounded to the specified number of decimal places
    • If num_digits is 0, number is rounded to the nearest integer
    • If num_digits is less than 0, number is rounded to the left of the decimal point

ROUNDUP function

1.   ROUNDUP function rounds any number that contains a decimal value up to the next higher number. ROUNDUP function behaves like ROUND function except that it always rounds a number up

2.   General syntax: ROUNDUP(number,num_digits)

  • number: any real number that you want rounded up
  • num_digits:the number of digits to which you want to round number
    • If num_digits is greater than 0 (zero), number is rounded up the specified number of decimal places
    • If num_digits is 0, number is rounded up the nearest integer
    • If num_digits is less than 0, number is rounded up the left of the decimal point

 

 

 

 

 

 

ROUNDDOWN function

1.   ROUNDDOWN function rounds any number that contains a decimal value down to the next lower number. ROUNDDOWN function behaves like ROUND function except that it always rounds a number down

2.   General syntax: ROUNDDOWN(number,num_digits)

  • number: any real number that you want rounded down
  • num_digits: the number of digits to which you want to round number
    • If num_digits is greater than 0 (zero), number is rounded down the specified number of decimal places
    • If num_digits is 0, number is rounded down the nearest integer
    • If num_digits is less than 0, number is rounded down the left of the decimal point

 

 

 

 

 

 

MROUND function

1.   MROUND function rounds the number to the nearest one-half, or quarter, or even the closet value of seven

2.   General syntax: MROUND(number,multiple)

  • number: the value to round
  • multiple: the multiple to which you want to round number

NOTE

  • MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple
  • The number argument and the multiple argument must have the same sign