Math and trig functions

Application: Spreadsheet Education

Name	Description	Syntax
ABS	Returns the number without its sign (absolute value)	ABS(value)
ACOS	Returns the arccosine of a number	ACOS(value)
ACOSH	Returns the inverse hyperbolic cosine of a number	ACOSH(value)
ACOT	Returns the arccotangent of a number	ACOT(value)
ASIN	Returns the arcsine of a number	ASIN(value)
ATAN	Returns the arctangent of a number	ATAN(value)
ATAN2	Returns the arctangent of the specified coordinates, which is the angle between the X-axis and a line from the origin to the required point	ATAN2(x, y)
ATANH	Calculates the inverse hyperbolic tangent for a number.	ATANH(value)
COSH	Returns the hyperbolic cosine of a number	COSH(value)
COTH	Returns the hyperbolic cotangent of a number	COTH(value)
CSC	Returns the cosecant of the angle specified in radians.	CSC(angle)
CSCH	Returns the hyperbolic cosecant of a number	CSCH(value)
EXP	Raises the constant e (approximately equal to 2.718) to a specified power	EXP(power)
LN	Returns the natural logarithm of a number. Base is the constant e, approximately equal to 2.718	LN(value)
LOG	Returns the logarithm of a number to a given base	LOG(value, [base])
LOG10	Returns the logarithm of a number to the base 10	LOG10(value)
SEC	Returns the secant of an angle	SEC(angle)
SECH	Returns the hyperbolic secant of a number	SECH(value)
SINH	Returns the hyperbolic sine of a number	SINH(value)
TANH	Returns the hyperbolic tangent of a number	TANH(value)
DEGREES	Returns an angle value in degrees	DEGREES(angle)
FACTDOUBLE	Returns the double factorial of a number	FACTDOUBLE(value)
SQRT	Returns the square root of a number	SQRT(value)
SQRTPI	Returns the square root of the product of π (3.1415…) and a specified value	SQRTPI(value)
ROUND	Rounds a value to a specified number of places before or after the decimal point	ROUND(value, places)
ROUNDUP	Rounds a value up to a specified number of places before or after the decimal point	ROUNDUP(value, places)
ROUNDDOWN	Rounds a value down to a specified number of places before or after the decimal point	ROUNDDOWN(value, places)
PI	Returns the number π accurate to 10 digits after the decimal point	PI()
PRODUCT	Returns the product of all values	PRODUCT(value1, [value2, ...])
SUBTOTAL	Returns subtotals for a range of numbers applying another function	SUBTOTAL( function_code, range1, [range2, ...])
RAND	Returns a random decimal number that is greater than or equal to 0 and less than 1	RAND()
POWER	Raises a number to a specified power	POWER(value, power)
SUM	Returns the sum of all values	SUM(value1, [value2, ... ])
SUMIF	Returns the sum of the values that meet the given criterion	SUMIF(range, criterion, [sum_range])
SUMIFS	Adds range values that meet all specified criteria	SUMIFS(sum_range, criterion_range1, criterion1, [criterion_range2, criterion2, ...])
SUMSQ	Returns the sum of the squares of all values	SUMSQ(value1, [value2, ... ])
SUMPRODUCT	Returns the sum of products of corresponding values in arrays or ranges	SUMPRODUCT(array1, [array2, ...])
FACT	Returns the factorial of a number	FACT(value)
INT	Rounds a number down to the nearest integer	INT(value)
QUOTIENT	Returns the integer part of a division	QUOTIENT(dividend, divisor)

Was this helpful?

Yes