SpreadCE Help

Math/trigonometry functions

[ ] indicates optional parameters

ABS(number)
ACOS(number)
ACOSH(number)
ASIN(number)
ASINH(number)
ATAN(number)
ATAN2(x_num, y_num)
ATANH(number)
CEILING(number, significance)
COMBIN(number, number_chosen)
COS(number)
COSH(number)
COUNTIF(range, criteria)
DEGREES(angle)
EVEN(number)
EXP(number)
FACT(number)
FACTDOUBLE(number)
FLOOR(number, significance)
GCD(number1, [number2, ...])
INT(number)
LCM(number1, [number2, ...])
LN(number)
LOG(number, [base])
LOG10(number)
MDETERM(range)
MINVERSE(array)
MMULT(array1, array2)
MOD(number, divisor)
MROUND(number, multiple)
MULTINOMIAL(number1, [number2, ...])
ODD(number)
PI()
POWER(number, power)
PRODUCT(number1, [number2, ...])
QUOTIENT(numerator, denominator)
RADIANS(angle)
RAND()
RANDBETWEEN(smallest, largest)
ROMAN(number, [form])
ROUND(number, num_digits)
ROUNDDOWN(number, [num_digits])
ROUNDUP(number, [num_digits])
SERIESSUM(x, n, m, coefficients)
SIGN(number)
SIN(number)
SINH(number)
SQRT(number)
SQRTPI(number)
SUBTOTAL(function_num, ref1, [ref2, ...])
SUM(number1, [number2, ...])
SUMIF(range, criteria, [sum_range])
SUMPRODUCT(range1, [range2, ...])
SUMSQ(number1, [number2, ...])
SUMX2MY2(x_range, y_range)
SUMX2PY2(x_range, y_range)
SUMXMY2(x_range, y_range)
TAN(number)
TANH(number)
TRUNC(number, [num_digits])

Math/trigonometry functions

ABS(number)

Returns the absolute value of a number.

number | The number for which you want the absolute value.

ACOS(number)

Returns the angle in radians corresponding to the arccosine of a number.

number | The number for which you want the arccosine.

ACOSH(number)

Returns the angle in radians corresponding to the inverse hyperbolic cosine of a number.

number | The number for which you want the inverse hyperbolic cosine.

ASIN(number)

Returns the angle in radians corresponding to the arcsine of a number.

number | The number for which you want the arcsine.

ASINH(number)

Returns the angle in radians corresponding to the inverse hyperbolic sine of a number.

number | The number for which you want the inverse hyperbolic sine.

ATAN(number)

Returns the angle in radians corresponding to the arctangent of a number.

number | The number for which you want the arctangent.

ATAN2(x_num, y_num)

Returns the angle in radians corresponding to a pair of co-ordinates.

x_num | The x co-ordinate for which you want the angle.
y_num | The y co-ordinate for which you want the angle.

ATANH(number)

Returns the angle in radians corresponding to the inverse hyperbolic tangent of a number.

number | The number for which you want the inverse hyperbolic tangent.

CEILING(number, significance)

Returns the number rounded up (away from zero) to the next multiple of significance.

number | The number which you want rounded.
significance | The units you want to use for rounding.

COMBIN(number, number_chosen)

Returns the number of combinations in which a number of items can be chosen from a total number.

number | The total number of items.
number_chosen | The number of items chosen.

COS(number)

Returns the cosine of an angle.

number | The angle for which you want the cosine. It must be specified in radians.

COSH(number)

Returns the hyperbolic cosine of an angle.

number | The angle for which you want the hyperbolic cosine. It must be specified in radians.

COUNTIF(range, criteria)

Returns the number of cells in a specified range that meet the specified criteria.

range | A reference to the cells you want to count.
criteria | A string containing a comparison expression.

DEGREES(angle)

Converts an angle from radians to degrees.

angle | The angle that you want to convert.

EVEN(number)

Returns the number rounded up to the next even number.

number | The number which you want rounded.

EXP(number)

Returns the e raised to the power number.

number | The power to which you want to raise e.

FACT(number)

Returns the factorial of a number.

number | The number of which you want the factorial.

FACTDOUBLE(number)

Returns the double factorial of a number.

number | The number of which you want the double factorial.

FLOOR(number, significance)

Returns the number rounded down (towards zero) to the next multiple of significance.

number | The number which you want rounded.
significance | The units you want to use for rounding.

GCD(number1, [number2, ...])

Returns the greatest common divisor of a set of numbers.

number1, ... | The numbers of which you want the greatest common divisor.

INT(number)

Returns the number rounded down to the next integer.

number | The number which you want rounded.

LCM(number1, [number2, ...])

Returns the lowest common multiple of a set of numbers.

number1, ... | The numbers of which you want the lowest common multiple.

LN(number)

Returns the natural logarithm of a number.

number | The number for which you want the natural logarithm.

LOG(number, [base])

Returns the logarithm of a number in a specified base.

number | The number for which you want the logarithm.
base | The base in which you want the logarithm. If this parameter is omitted it defaults to 10.

LOG10(number)

Returns the base 10 logarithm of a number.

number | The number for which you want the base 10 logarithm.

MDETERM(range)

Returns the determinant of a matrix.

range | An array or reference to cells containing the matrix.

MINVERSE(array)

Returns the inverse of a matrix.

array | An array or reference to cells containing the matrix.

MMULT(array1, array2)

Returns the product of two matrices.

array1 | An array or reference to cells containing the first matrix.
array2 | An array or reference to cells containing the second matrix.

MOD(number, divisor)

Returns the remainder of a division.

number | The dividend.
divisor | The divisor.

MROUND(number, multiple)

Returns the number rounded to a multiple.

number | The number that you want rounded.
multiple | The multiple to which you want the number rounded.

MULTINOMIAL(number1, [number2, ...])

Returns the factorial of the sum of the values divided by the product of their factorials.

number1, ... | The numbers of which you want the multinomial.

ODD(number)

Returns the number rounded up to the next odd number.

number | The number which you want rounded.

PI()

Returns the value of Pi.

POWER(number, power)

Returns the number raised to the power.

number | The number which you want raised to a power.
power | The power to which you want to raise the number.

PRODUCT(number1, [number2, ...])

Returns the product of a list of numbers.

number1, ... | The numbers that you want to multiply together.

QUOTIENT(numerator, denominator)

Returns the integer result of a division.

numerator | The dividend.
denominator | The divisor.

RADIANS(angle)

Converts an angle from degrees to radians.

angle | The angle that you want to convert.

RAND()

Returns a random number between 0 and 1.

RANDBETWEEN(smallest, largest)

Returns a random integer in the range you specify.

smallest | The lower limit of the range.
largest | The upper limit of the range.

ROMAN(number, [form])

Returns a string representing a number converted to roman numerals.

number | The number that you want to convert.
form | Specifies the compactness of the representation. The possible values are:

0 | Classic
1 | More compact
2 | More compact
3 | More compact
4 | Simplified
TRUE | Classic
FALSE | Simplified

| If this parameter is omitted it defaults to 0.

ROUND(number, num_digits)

Returns a number rounded to the number of decimal places specified.

number | The number that you want rounded.
num_digits | The number of decimal places to round to (may be negative).

ROUNDDOWN(number, [num_digits])

Returns a number rounded down to the number of decimal places specified.

number | The number that you want rounded.
num_digits | The number of decimal places to round to (may be negative). If this parameter is omitted it defaults to 0.

ROUNDUP(number, [num_digits])

Returns a number rounded up to the number of decimal places specified.

number | The number that you want rounded.
num_digits | The number of decimal places to round to (may be negative). If this parameter is omitted it defaults to 0.

SERIESSUM(x, n, m, coefficients)

Returns the value of a polynomial.

x | The number to be raised to a power.
n | The power of the first term in the series.
m | The difference between successive powers in the series.
coefficients | An array or reference to cells containing the coefficients.

SIGN(number)

Returns the sign of a number; 1 for positive, -1 for negative and 0 for zero.

number | The number of which you want the sign.

SIN(number)

Returns the sine of an angle.

number | The angle for which you want the sine. It must be specified in radians.

SINH(number)

Returns the hyperbolic sine of an angle.

number | The angle for which you want the hyperbolic sine. It must be specified in radians.

SQRT(number)

Returns the square root of a number.

number | The number of which you want the square root.

SQRTPI(number)

Returns the square root of a number after it is multiplied by Pi.

number | The number which you want to multiply by Pi and then take the square root.

SUBTOTAL(function_num, ref1, [ref2, ...]);

Returns the subtotal of values in one or more ranges, excluding other subtotal figures.

function_num | The subtotal function that you want. The possible values are:

1 | AVERAGE
2 | COUNT
3 | COUNTA
4 | MAX
5 | MIN
6 | PRODUCT
7 | STDEV
8 | STDEVP
9 | SUM
10 | VAR
11 | VARP

ref1, ... | The ranges of cells that you want subtotalled.

SUM(number1, [number2, ...])

Returns the sum of a list of numbers.

number1, ... | The numbers that you want to add together.

SUMIF(range, criteria, [sum_range])

Returns the sum of cells in a specified range that meet the specified criteria.

range | A reference to the cells you want to check.
criteria | A string containing a comparison expression.
sum_range | A range containing values to be summed where the values in the first range meet the specified criteria. If this parameter is omitted then the values in the first range are summed.

SUMPRODUCT(range1, [range2, ...])

Returns the sum of the products of the cells in one or more ranges.

range1, ... | The ranges of cells where corresponding values are multiplied together and then summed.

SUMSQ(number1, [number2, ...])

Returns the sum of the squares of the numbers in the list.

number1, ... | The numbers that are to be squared and then summed.

SUMX2MY2(x_range, y_range)

Returns the sum of the differences of the squares of the numbers in the ranges.

x_range | The first range of numbers.
y_range | The second range of numbers.

SUMX2PY2(x_range, y_range)

Returns the sum of the sums of the squares of the numbers in the ranges.

x_range | The first range of numbers.
y_range | The second range of numbers.

SUMXMY2(x_range, y_range)

Returns the sum of the squares of the differences of the numbers in the ranges.

x_range | The first range of numbers.
y_range | The second range of numbers.

TAN(number)

Returns the tangent of an angle.

number | The angle for which you want the tangent. It must be specified in radians.

TANH(number)

Returns the hyperbolic tangent of an angle.

number | The angle for which you want the hyperbolic tangent. It must be specified in radians.

TRUNC(number, [num_digits])

Returns a number truncated to the number of decimal places specified.

number | The number that you want truncated.
num_digits | The number of decimal places to truncate to (may be negative).