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