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