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