Openoffice Calc Floor Function

Places returns number rounded down towards zero to places decimal places.

Openoffice calc floor 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. It defaults to 1 or 1 depending on the sign of number. Calculates the modified bessel function of the first kind. Calculates the bessel function of the first kind.

This function rounds towards zero. Date time functions. The solution to storing all your numbers and lists. Returns a number rounded up to a multiple of another number.

This function rounds to the nearest number. If places is omitted or zero the function rounds to the nearest integer. If places is omitted or zero the function rounds down to an integer. Returns the absolute.

This is only relevant with negative numbers. Rounds a number down toward zero to a certain precision. Int number returns number rounded down to the nearest integer. Excess decimal places are simply removed irrespective of sign.

Calc is the spreadsheet application you ve always wanted. Truncates a number by removing decimal places. The database functions are used to extract information from calc data tables where data is organised in rows. Calculates the modified bessel function of the second kind.

Dcount dcounta dget dmax dmin daverage dproduct dstdev dstdevp dsum dvar dvarp. Places returns number rounded to places decimal places. Rounds a number down to the nearest integer. Rounds a number to a certain precision.

See rounddown and roundup for alternatives. Negative numbers round down to the integer below. Mode optional is a number or a reference to a cell containing a number. If places is negative the function rounds to the nearest 10 100 1000 etc.

Calculates the bessel function of the second kind the neumann or weber function. If places is negative the function rounds down to the next 10 100 1000 etc. Places returns number with at most places decimal places. 1 3 rounds to 2.

Newcomers find it intuitive and easy to learn. Mode number is the number that is to be rounded or a reference to a cell containing the number. Significance optional is the value or a reference to a cell containing the value to whose multiple number is to be rounded.