If places is negative the function rounds to the nearest 10 100 1000 etc.
Openoffice calc floor function.
Places returns number rounded to places decimal places.
Int number returns number rounded down to the nearest integer.
The database functions are used to extract information from calc data tables where data is organised in rows.
Dcount dcounta dget dmax dmin daverage dproduct dstdev dstdevp dsum dvar dvarp.
Rounds a number to a certain precision.
Newcomers find it intuitive and easy to learn.
Calculates the modified bessel function of the first kind.
If places is negative the function rounds down to the next 10 100 1000 etc.
Calculates the modified bessel function of the second kind.
Professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.
Truncates a number by removing decimal places.
If places is omitted or zero the function rounds down to an integer.
Excess decimal places are simply removed irrespective of sign.
Mode number is the number that is to be rounded or a reference to a cell containing the number.
See rounddown and roundup for alternatives.
Places returns number with at most places decimal places.
It defaults to 1 or 1 depending on the sign of number.
Negative numbers round down to the integer below.
This function rounds towards zero.
If places is omitted or zero the function rounds to the nearest integer.
This is only relevant with negative numbers.
Returns the absolute.
Significance optional is the value or a reference to a cell containing the value to whose multiple number is to be rounded.
Date time functions.
This function rounds to the nearest number.
Calc is the spreadsheet application you ve always wanted.
Rounds a number down to the nearest integer.
Calculates the bessel function of the first kind.
Mode number is the number that is to be rounded up to a multiple of mult.
Rounds a number down toward zero to a certain precision.
Calculates the bessel function of the second kind the neumann or weber function.
If mode is zero or omitted ceiling rounds up to the multiple above greater than or equal to number if mode is non zero ceiling rounds up away from zero.
The date time functions are used to manipulate dates and times.
Mode optional is a number or a reference to a cell containing a number.
1 3 rounds to 2.
