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