Maths & Trigonometry Functions

ABSThe absolute value or a number without its sign.
ACOSThe arc-cosine of a number.
ACOSHThe hyperbolic arc-cosine of a number.
ACOT(2013) The arc-cotangent of a number.
ACOTH(2013) The hyperbolic arc-cotangent of a number.
AGGREGATE(2010) The aggregate of values in a list, table or cell range.
ARABIC(2013) The number converted from roman to arabic.
ASINThe arc-sine of a number.
ASINHThe hyperbolic arc-sine of a number.
ATANThe arc-tangent of a number.
ATAN2The arc-tangent of the specified x and y co-ordinates.
ATANHThe hyperbolic arc-tangent of a number.
BASE(2013) The number converted into a text representation with the given base.
CEILING(CEILING.MATH) The number rounded up to the nearest integer or significant figure.
CEILING.MATH(2013) The number rounded up to the nearest integer or significant figure (including negative).
CEILING.PRECISE(CEILING.MATH) The number rounded up to the nearest integer or significant figure.
COMBINThe number of combinations for a given number of items.
COMBINA(2013) The number of combinations for a given number of items (with repetition).
COSThe cosine of a number.
COSHThe hyperbolic cosine of a number.
COT(2013) The cotangent of a number.
COTH(2013) The hyperbolic cotangent of a number.
CSC(2013) The cosecant of a number.
CSCH(2013) The hyperbolic cosecant of a number.
DECIMAL(2013) The decimal number of a text representation of a number in a given base.
DEGREESThe number of degrees given a number of radians.
EVENThe number rounded up to the nearest even integer.
EXPThe exponential number raised to a particular power.
FACTThe factorial of a number.
FACTDOUBLEThe double factorial of a number.
FLOOR(FLOOR.MATH) The number rounded down to the nearest integer or significant figure.
FLOOR.MATH(2013) The number rounded down to the nearest integer or significant figure (inc. negative).
FLOOR.PRECISE(FLOOR.MATH) The number rounded down to the nearest integer or significant figure.
GCDThe greatest common divisor of two or more numbers.
INTThe number rounded down to the nearest integer.
ISO.CEILING(CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed).
LCMThe least common multiple of two or more numbers.
LNThe natural logarithm of a number.
LOGThe logarithm of a number to any base.
LOG10The logarithm of a number to the base 10.
MDETERMThe matrix determinant of an array.
MINVERSEThe inverse matrix of an array.
MMULTThe matrix product of two arrays.
MODThe remainder after division.
MROUNDThe number rounded to the desired multiple.
MULTINOMIALThe multinomial of a set of numbers in a list or cell range.
MUNIT(2013) The unit matrix or the specified dimension.
ODDThe number rounded up to the nearest odd integer.
PIThe number PI (3.141592).
POWERThe number raised to a given power.
PRODUCTThe product of all the numbers in a list or cell range.
QUOTIENTThe integer portion after division.
RADIANSThe number of radians given the number of degrees.
RANDThe random number >=0 and <1.
RANDARRAY(2019) The array of random numbers between 0 and 1.
RANDBETWEENThe random number between two specified numbers (inclusive).
ROMANThe text string converting a binary number to a roman numeral.
ROUNDThe number rounded to a specified number of digits.
ROUNDDOWNThe number rounded down to the nearest integer.
ROUNDUPThe number rounded up to the nearest integer.
SEC(2013) The secant of a number.
SECH(2013) The hyperbolic secant of a number.
SEQUENCE(2019) The array of sequential numbers.
SERIESSUMThe sum of a power series based on a formula.
SIGNThe numerical value indicating if a number is positive or negative.
SINThe sine of a number.
SINHThe hyperbolic sine of a number.
SQRTThe positive square root of a number.
SQRTPIThe square root of a number multiplied by PI.
SUBTOTAL(AGGREGATE) The subtotal of values in a list, table or cell range.
SUMThe total value of the numbers in a list, table or cell range.
SUMIFThe total value of the numbers that satisfies one condition.
SUMIFSThe total value of the numbers that satisfies multiple conditions.
SUMPRODUCTThe sum of the product of one or more arrays of values.
SUMSQThe sum of the squares of all the values in a list, table or cell range.
SUMX2MY2The sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2The sum of the sum of squares of corresponding values in two arrays.
SUMXMY2The sum of squares of differences of corresponding values in two arrays.
TANThe tangent of a number.
TANHThe hyperbolic tangent of a number.
TRUNCThe number with any decimal places removed.
ABS
The absolute value or a number without its sign.
ACOS
The arc-cosine of a number.
ACOSH
The hyperbolic arc-cosine of a number.
ACOT
(2013) The arc-cotangent of a number.
ACOTH
(2013) The hyperbolic arc-cotangent of a number.
AGGREGATE
(2010) The aggregate of values in a list, table or cell range.
ARABIC
(2013) The number converted from roman to arabic.
ASIN
The arc-sine of a number.
ASINH
The hyperbolic arc-sine of a number.
ATAN
The arc-tangent of a number.
ATAN2
The arc-tangent of the specified x and y co-ordinates.
ATANH
The hyperbolic arc-tangent of a number.
BASE
(2013) The number converted into a text representation with the given base.
CEILING
(CEILING.MATH) The number rounded up to the nearest integer or significant figure.
CEILING.MATH
(2013) The number rounded up to the nearest integer or significant figure (including negative).
CEILING.PRECISE
(CEILING.MATH) The number rounded up to the nearest integer or significant figure.
COMBIN
The number of combinations for a given number of items.
COMBINA
(2013) The number of combinations for a given number of items (with repetition).
COS
The cosine of a number.
COSH
The hyperbolic cosine of a number.
COT
(2013) The cotangent of a number.
COTH
(2013) The hyperbolic cotangent of a number.
CSC
(2013) The cosecant of a number.
CSCH
(2013) The hyperbolic cosecant of a number.
DECIMAL
(2013) The decimal number of a text representation of a number in a given base.
DEGREES
The number of degrees given a number of radians.
EVEN
The number rounded up to the nearest even integer.
EXP
The exponential number raised to a particular power.
FACT
The factorial of a number.
FACTDOUBLE
The double factorial of a number.
FLOOR
(FLOOR.MATH) The number rounded down to the nearest integer or significant figure.
FLOOR.MATH
(2013) The number rounded down to the nearest integer or significant figure (inc. negative).
FLOOR.PRECISE
(FLOOR.MATH) The number rounded down to the nearest integer or significant figure.
GCD
The greatest common divisor of two or more numbers.
INT
The number rounded down to the nearest integer.
ISO.CEILING
(CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed).
LCM
The least common multiple of two or more numbers.
LN
The natural logarithm of a number.
LOG
The logarithm of a number to any base.
LOG10
The logarithm of a number to the base 10.
MDETERM
The matrix determinant of an array.
MINVERSE
The inverse matrix of an array.
MMULT
The matrix product of two arrays.
MOD
The remainder after division.
MROUND
The number rounded to the desired multiple.
MULTINOMIAL
The multinomial of a set of numbers in a list or cell range.
MUNIT
(2013) The unit matrix or the specified dimension.
ODD
The number rounded up to the nearest odd integer.
PI
The number PI (3.141592).
POWER
The number raised to a given power.
PRODUCT
The product of all the numbers in a list or cell range.
QUOTIENT
The integer portion after division.
RADIANS
The number of radians given the number of degrees.
RAND
The random number >=0 and <1.
RANDARRAY
(2019) The array of random numbers between 0 and 1.
RANDBETWEEN
The random number between two specified numbers (inclusive).
ROMAN
The text string converting a binary number to a roman numeral.
ROUND
The number rounded to a specified number of digits.
ROUNDDOWN
The number rounded down to the nearest integer.
ROUNDUP
The number rounded up to the nearest integer.
SEC
(2013) The secant of a number.
SECH
(2013) The hyperbolic secant of a number.
SEQUENCE
(2019) The array of sequential numbers.
SERIESSUM
The sum of a power series based on a formula.
SIGN
The numerical value indicating if a number is positive or negative.
SIN
The sine of a number.
SINH
The hyperbolic sine of a number.
SQRT
The positive square root of a number.
SQRTPI
The square root of a number multiplied by PI.
SUBTOTAL
(AGGREGATE) The subtotal of values in a list, table or cell range.
SUM
The total value of the numbers in a list, table or cell range.
SUMIF
The total value of the numbers that satisfies one condition.
SUMIFS
The total value of the numbers that satisfies multiple conditions.
SUMPRODUCT
The sum of the product of one or more arrays of values.
SUMSQ
The sum of the squares of all the values in a list, table or cell range.
SUMX2MY2
The sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2
The sum of the sum of squares of corresponding values in two arrays.
SUMXMY2
The sum of squares of differences of corresponding values in two arrays.
TAN
The tangent of a number.
TANH
The hyperbolic tangent of a number.
TRUNC
The number with any decimal places removed.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top