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.

numberThe number for which you want the absolute value.



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

numberThe number for which you want the arccosine.



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

numberThe number for which you want the inverse hyperbolic cosine.



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

numberThe number for which you want the arcsine.



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

numberThe number for which you want the inverse hyperbolic sine.



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

numberThe 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_numThe x co-ordinate for which you want the angle.
y_numThe 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.

numberThe 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.

numberThe number which you want rounded.
significanceThe 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.

numberThe total number of items.
number_chosenThe number of items chosen.



COS(number)
Returns the cosine of an angle.

numberThe angle for which you want the cosine. It must be specified in radians.



COSH(number)
Returns the hyperbolic cosine of an angle.

numberThe 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.

rangeA reference to the cells you want to count.
criteriaA string containing a comparison expression.



DEGREES(angle)
Converts an angle from radians to degrees.

angleThe angle that you want to convert.



EVEN(number)
Returns the number rounded up to the next even number.

numberThe number which you want rounded.



EXP(number)
Returns the e raised to the power number.

numberThe power to which you want to raise e.



FACT(number)
Returns the factorial of a number.

numberThe number of which you want the factorial.



FACTDOUBLE(number)
Returns the double factorial of a number.

numberThe number of which you want the double factorial.



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

numberThe number which you want rounded.
significanceThe 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.

numberThe 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.

numberThe number for which you want the natural logarithm.



LOG(number, [base])
Returns the logarithm of a number in a specified base.

numberThe number for which you want the logarithm.
baseThe 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.

numberThe number for which you want the base 10 logarithm.



MDETERM(range)
Returns the determinant of a matrix.

rangeAn array or reference to cells containing the matrix.



MINVERSE(array)
Returns the inverse of a matrix.

arrayAn array or reference to cells containing the matrix.



MMULT(array1, array2)
Returns the product of two matrices.

array1An array or reference to cells containing the first matrix.
array2An array or reference to cells containing the second matrix.



MOD(number, divisor)
Returns the remainder of a division.

numberThe dividend.
divisorThe divisor.



MROUND(number, multiple)
Returns the number rounded to a multiple.

numberThe number that you want rounded.
multipleThe 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.

numberThe number which you want rounded.



PI()
Returns the value of Pi.


POWER(number, power)
Returns the number raised to the power.

numberThe number which you want raised to a power.
powerThe 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.

numeratorThe dividend.
denominatorThe divisor.



RADIANS(angle)
Converts an angle from degrees to radians.

angleThe 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.

smallestThe lower limit of the range.
largestThe upper limit of the range.



ROMAN(number, [form])
Returns a string representing a number converted to roman numerals.

numberThe number that you want to convert.
formSpecifies the compactness of the representation. The possible values are:

0Classic
1More compact
2More compact
3More compact
4Simplified
TRUEClassic
FALSESimplified

If this parameter is omitted it defaults to 0.



ROUND(number, num_digits)
Returns a number rounded to the number of decimal places specified.

numberThe number that you want rounded.
num_digitsThe 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.

numberThe number that you want rounded.
num_digitsThe 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.

numberThe number that you want rounded.
num_digitsThe 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.

xThe number to be raised to a power.
nThe power of the first term in the series.
mThe difference between successive powers in the series.
coefficientsAn 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.

numberThe number of which you want the sign.



SIN(number)
Returns the sine of an angle.

numberThe angle for which you want the sine. It must be specified in radians.



SINH(number)
Returns the hyperbolic sine of an angle.

numberThe angle for which you want the hyperbolic sine. It must be specified in radians.



SQRT(number)
Returns the square root of a number.

numberThe number of which you want the square root.



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

numberThe 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_numThe subtotal function that you want. The possible values are:

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

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.

rangeA reference to the cells you want to check.
criteriaA string containing a comparison expression.
sum_rangeA 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_rangeThe first range of numbers.
y_rangeThe 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_rangeThe first range of numbers.
y_rangeThe 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_rangeThe first range of numbers.
y_rangeThe second range of numbers.



TAN(number)
Returns the tangent of an angle.

numberThe angle for which you want the tangent. It must be specified in radians.



TANH(number)
Returns the hyperbolic tangent of an angle.

numberThe 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.

numberThe number that you want truncated.
num_digitsThe number of decimal places to truncate to (may be negative).