Rounding Functions in Excel

Rounding Functions in Excel









Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a multiple of significance


Rounds a number up, regardless of the sign of the number, to a multiple of significance (New in Excel 2010)


Rounds a number up to the nearest integer or to the nearest multiple of significance (New in Excel 2013)





Rounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a multiple of significance


Rounds a number down, regardless of the sign of the number, to a multiple of significance (New in Excel 2010)



Rounds a number down, to the nearest integer or to the nearest multiple of significance (New in Excel 2013)





Rounds a number up or down, to a given number of digits


Rounds a number up or down, to the nearest multiple of significance





Rounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a given number of digits


Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a given number of digits





Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next even number


Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next odd number





Rounds a number down to the next integer


Truncates a number towards zero (i.e. rounds a positive number down and a negative number up), to the next integer.

Comments

Popular posts from this blog

Formatting a Range of Cells In Excel VBA

Trunc() Function

BREAK THE PASSWORD OF THE SHEET IN EXCEL