Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

  




 

 

OpenOffice Calc User Guide
Previous Page Home Next Page

Mathematical functions

Table 10: Mathematical functions

Syntax

Description

ABS(number)

Returns the absolute value of the given number.

ACOS(number)

Returns the inverse cosine of the given number in radians.

ACOSH(number)

Returns the inverse hyperbolic cosine of the given number in radians.

ACOT(number)

Returns the inverse cotangent of the given number in radians.

ACOTH(number)

Returns the inverse hyperbolic cotangent of the given number in radians.

ASIN(number)

Returns the inverse sine of the given number in radians.

ASINH(number)

Returns the inverse hyperbolic sine of the given number in radians.

ATAN(number)

Returns the inverse tangent of the given number in radians.

ATAN2(number_x; number_y)

Returns the inverse tangent of the specified x and y coordinates. Number_x is the value for the x coordinate. Number_y is the value for the y coordinate.

ATANH(number)

Returns the inverse hyperbolic tangent of the given number. (Angle is returned in radians.)

CEILING(number; significance; mode)

Rounds the given number to the nearest integer or multiple of significance. Significance is the value to whose multiple of ten the value is to be rounded up (.01, .1, 1, 10, etc.). Mode is an optional value. If it is indicated and non-zero and if the number and significance are negative, rounding up is carried out based on that value.

COMBIN(count_1; count_2)

Returns the number of combinations for a given number of objects. Count_1 is the total number of elements. Count_2 is the selected count from the elements. This is the same as the nCr function on a calculator.

COMBINA(count_1; count_2)

Returns the number of combinations for a given number of objects (repetition included). Count_1 is the total number of elements. Count_2 is the selected count from the elements.

CONVERT(value; "text"; "text")

Converts a currency value of a European currency into Euros. Value is the amount in the currency to be converted. Text is the official abbreviation for the currency in question (for example, "EUR"). The first Text parameter gives the source value to be converted; the second Text parameter gives the destination value. Both text arguments must be within quotes.

COS(number)

Returns the cosine of the given number (angle in radians).

COSH(number)

Returns the hyperbolic cosine of the given number (angle in radians).

COT(number)

Returns the cotangent of the given number (angle in radians).

COTH(number)

Returns the hyperbolic cotangent of the given number (angle in radians).

COUNTBLANK(range)

Returns the number of empty cells. Range is the cell range in which the empty cells are counted.

COUNTIF(range; criteria)

Returns the number of elements that meet certain criteria within a cell range. Range is the range to which the criteria are to be applied. Criteria indicates the criteria in the form of a number, a regular expression, or a character string by which the cells are counted.

DEGREES(number)

Converts the given number in radians to degrees.

EVEN(number)

Rounds the given number up to the nearest even integer.

EXP(number)

Returns e raised to the power of the given number.

FACT(number)

Returns the factorial of the given number.

FLOOR(number; significance; mode)

Rounds the given number down to the nearest multiple of significance. Significance is the value to whose multiple of ten the number is to be rounded down (.01, .1, 1, 10, etc.). Mode is an optional value. If it is indicated and non-zero and if the number and significance are negative, rounding up is carried out based on that value.

GCD(numbers)

Returns the greatest common divisor of one or more integers. Numbers is a list of up to 30 numbers whose greatest common divisor is to be calculated, separated by semi-colons.

*GCD_ADD(numbers)

Returns the greatest common divisor of a list of numbers. Numbers is a list of up to 30 numbers separated by semi-colons.

INT(number)

Rounds the given number down to the nearest integer.

ISEVEN(value)

Returns TRUE if the given value is an even integer, or FALSE if the value is odd. If the value is not an integer, the function evaluates only the integer part of the value.

ISODD(value)

Returns TRUE if the given value is an odd integer, or FALSE if the value is even. If the value is not an integer, the function evaluates only the integer part of the value.

LCM(integer_1; integer_2; ... integer_30)

Returns the least common multiple of one or more integers. Integer_1; integer_2;... integer_30 are integers whose lowest common multiple is to be calculated.

*LCM_ADD(numbers)

Numbers is a list of up to 30 numbers separated by semi-colons. The result is the lowest common multiple of a list of numbers.

LN(number)

Returns the natural logarithm based on the constant e of the given number.

LOG(number; base)

Returns the logarithm of the given number to the specified base. Base is the base for the logarithm calculation.

LOG10(number)

Returns the base-10 logarithm of the given number.

MOD(dividend; divisor)

Returns the remainder after a number is divided by a divisor. Dividend is the number which will be divided by the divisor. Divisor is the number by which to divide the dividend.

*MROUND(number; multiple)

The result is the nearest integer multiple of the number.

*MULTINOMIAL (number(s))

Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments. Number(s) is a list of up to 30 numbers separated by semi-colons.

ODD(number)

Rounds the given number up to the nearest odd integer.

PI()

Returns the value of PI to fourteen decimal places.

POWER(base; power)

Returns the result of a number raised to a power. Base is the number that is to be raised to the given power. Power is the exponent by which the base is to be raised.

PRODUCT(number 1 to 30)

Multiplies all the numbers given as arguments and returns the product. Number 1 to number 30 are up to 30 arguments whose product is to be calculated, separated by semi-colons.

*QUOTIENT(numerator; denominator)

Returns the integer result of a division operation. Numerator is the number that will be divided. Denominator is the number the numerator will be divided by.

RADIANS(number)

Converts the given number in degrees to radians.

RAND()

Returns a random number between 0 and 1. This number will recalculate every time data is entered or F9 is pressed.

*RANDBETWEEN (bottom; top)

Returns an integer random number between bottom and top (inclusive). This number will recalculate when the Control+Shift+F9 key combination is pressed.

ROUND(number; count)

Rounds the given number to a certain number of decimal places according to valid mathematical criteria. Count (optional) is the number of the places to which the value is to be rounded. If the count parameter is negative, only the whole number portion is rounded. It is rounded to the place indicated by the count.

ROUNDDOWN(number; count)

Rounds the given number. Count (optional) is the number of digits to be rounded down to. If the count parameter is negative, only the whole number portion is rounded. It is rounded to the place indicated by the count.

ROUNDUP(number; count)

Rounds the given number up. Count (optional) is the number of digits to which rounding up is to be done. If the count parameter is negative, only the whole number portion is rounded. It is rounded to the place indicated by the count.

*SERIESSUM(x; n; m; coefficients)

Returns a sum of powers of the number x in accordance with the following formula:

SERIESSUM(x;n;m;coefficients) = coefficient_1*x^n + coefficient_2*x^(n+m) + coefficient_3*x^(n+2m) +...+ coefficient_i*x^(n+(i-1)m).

x is the number as an independent variable. n is the starting power. m is the increment. Coefficients is a series of coefficients. For each coefficient the series sum is extended by one section. You can only enter coefficients using cell references.

SIGN(number)

Returns the sign of the given number. The function returns the result 1 for a positive sign, –1 for a negative sign, and 0 for zero.

SIN(number)

Returns the sine of the given number (angle in radians).

SINH(number)

Returns the hyperbolic sine of the given number (angle in radians).

SQRT(number)

Returns the positive square root of the given number. The value of the number must be positive.

*SQRTPI(number)

Returns the square root of the product of the given number and PI.

SUBTOTAL(function; range)

Calculates subtotals. If a range already contains subtotals, these are not used for further calculations. Function is a value that stands for another function such as Average, Count, Min, Sum, Var. Range is the range whose cells are included.

SUM(number_1; number_2; ... number_30)

Adds all the numbers in a range of cells. Number_1; number_2;... number_30 are up to 30 arguments whose sum is to be calculated. You can also enter a range using cell references.

SUMIF(range; criteria; sum_range)

Adds the cells specified by a given criteria. The search supports regular expressions. Range is the range to which the criteria are to be applied. Criteria is the cell in which the search criterion is shown, or the search criterion itself. Sum_range is the range from which values are summed; if it has not been indicated, the values found in the Range are summed.

SUMSQ(number_1; number_2; ... number_30)

Calculates the sum of the squares of numbers (totaling up of the squares of the arguments) Number_1; number_2;... number_30 are up to 30 arguments, the sum of whose squares is to be calculated.

TAN(number)

Returns the tangent of the given number (angle in radians).

TANH(number)

Returns the hyperbolic tangent of the given number (angle in radians).

TRUNC(number; count)

Truncates a number to an integer by removing the fractional part of the number according to the precision specified in Tools > Options > OpenOffice.org Calc > Calculate. Number is the number whose decimal places are to be cut off. Count is the number of decimal places which are not cut off.

OpenOffice Calc User Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire