Maths & Trigonometry Functions

ABSThe absolute value or a number without its sign.
ACOSThe angle in radians for a given cosine ratio.
ACOSHThe hyperbolic arc-cosine of a number.
ACOTThe arc-cotangent of a number.
ACOTHThe hyperbolic arc-cotangent of a number.
AGGREGATEThe choice of 19 different operations for numerical values (which can ignore hidden rows and errors).
ARABICThe number converted from roman to arabic.
ASINThe angle in radians for a given sine ratio.
ASINHThe hyperbolic arc-sine of a number.
ATANThe angle in radians for a given tangent ratio.
ATAN2The arc-tangent of the given x and y co-ordinates.
ATANHThe hyperbolic arc-tangent of a number.
BASEThe number converted into a text representation with the given base.
CEILING(Compatibility) The number rounded up to the nearest integer or multiple.
CEILING.MATHThe number rounded up to the nearest integer or multiple.
CEILING.PRECISE(CEILING.MATH) The number rounded up to the nearest integer or multiple.
COMBINThe number of combinations for a given number of items (without repetition).
COMBINAThe number of combinations for a given number of items (with repetition).
COSThe cosine of an angle.
COSHThe hyperbolic cosine of a number.
COTThe cotangent of a number.
COTHThe hyperbolic cotangent of a number.
CSCThe cosecant of a number.
CSCHThe hyperbolic cosecant of a number.
DECIMALThe decimal number of a text representation of a number in a given base.
DEGREESThe number of degrees given a number of radians.
ECMA.CEILING(CEILING.MATH)) The number rounded up to the nearest multiple of significance (renamed).
EVENThe number rounded to the nearest even integer.
EXPThe exponential number raised to a particular power.
FACTThe factorial of a positive whole number.
FACTDOUBLEThe double factorial of a positive whole number.
FLOOR(Compatibility) The number rounded down to the nearest integer or multiple.
FLOOR.MATHThe number rounded down to the nearest integer or multiple.
FLOOR.PRECISE(FLOOR.MATH) The number rounded down to the nearest integer or multiple.
GCDThe greatest common divisor of two or more numbers.
INTThe number rounded down to the nearest integer.
ISO.CEILING(CEILING.MATH) The number rounded up to the nearest integer or multiple (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 a certain multiple.
MULTINOMIALThe number of permutations for a given number of items (with duplicates).
MUNITThe unit matrix or the specified dimension.
ODDThe number rounded to the nearest odd integer.
PIThe number PI (3.141592).
POWERThe number raised to a given power.
PRODUCTThe product of all the numerical values.
QUOTIENTThe integer portion after division.
RADIANSThe number of radians given the number of degrees.
RANDThe random number between zero and one (>=0 and <1).
RANDARRAYThe array of random numbers between two values (>=min and <max).
RANDBETWEENThe random integer between two values (>=bottom and <=top).
ROMANThe text string converting a binary number to a roman numeral.
ROUNDThe number rounded to a certain number of decimal places or digits.
ROUNDDOWNThe number rounded down to a certain number of decimal places or digits.
ROUNDUPThe number rounded up to a certain number of decimal places or digits.
SECThe secant of a number.
SECHThe hyperbolic secant of a number.
SEQUENCEThe 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 an angle.
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 choice of 11 different operations for numerical values.
SUMThe total of the numerical values.
SUMIF(SUMIFS) The total of the numerical values that satisfies one condition.
SUMIFSThe total of the numerical values that satisfies multiple conditions.
SUMPRODUCTThe sum of the product of one or more arrays of values.
SUMSQThe variation of a data set from its mean.
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 an angle.
TANHThe hyperbolic tangent of a number.
TRUNCThe number truncated to a number of decimal places.
ABS
The absolute value or a number without its sign.
ACOS
The angle in radians for a given cosine ratio.
ACOSH
The hyperbolic arc-cosine of a number.
ACOT
The arc-cotangent of a number.
ACOTH
The hyperbolic arc-cotangent of a number.
AGGREGATE
The choice of 19 different operations for numerical values (which can ignore hidden rows and errors).
ARABIC
The number converted from roman to arabic.
ASIN
The angle in radians for a given sine ratio.
ASINH
The hyperbolic arc-sine of a number.
ATAN
The angle in radians for a given tangent ratio.
ATAN2
The arc-tangent of the given x and y co-ordinates.
ATANH
The hyperbolic arc-tangent of a number.
BASE
The number converted into a text representation with the given base.
CEILING
(Compatibility) The number rounded up to the nearest integer or multiple.
CEILING.MATH
The number rounded up to the nearest integer or multiple.
CEILING.PRECISE
(CEILING.MATH) The number rounded up to the nearest integer or multiple.
COMBIN
The number of combinations for a given number of items (without repetition).
COMBINA
The number of combinations for a given number of items (with repetition).
COS
The cosine of an angle.
COSH
The hyperbolic cosine of a number.
COT
The cotangent of a number.
COTH
The hyperbolic cotangent of a number.
CSC
The cosecant of a number.
CSCH
The hyperbolic cosecant of a number.
DECIMAL
The decimal number of a text representation of a number in a given base.
DEGREES
The number of degrees given a number of radians.
ECMA.CEILING
(CEILING.MATH)) The number rounded up to the nearest multiple of significance (renamed).
EVEN
The number rounded to the nearest even integer.
EXP
The exponential number raised to a particular power.
FACT
The factorial of a positive whole number.
FACTDOUBLE
The double factorial of a positive whole number.
FLOOR
(Compatibility) The number rounded down to the nearest integer or multiple.
FLOOR.MATH
The number rounded down to the nearest integer or multiple.
FLOOR.PRECISE
(FLOOR.MATH) The number rounded down to the nearest integer or multiple.
GCD
The greatest common divisor of two or more numbers.
INT
The number rounded down to the nearest integer.
ISO.CEILING
(CEILING.MATH) The number rounded up to the nearest integer or multiple (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 a certain multiple.
MULTINOMIAL
The number of permutations for a given number of items (with duplicates).
MUNIT
The unit matrix or the specified dimension.
ODD
The number rounded 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 numerical values.
QUOTIENT
The integer portion after division.
RADIANS
The number of radians given the number of degrees.
RAND
The random number between zero and one (>=0 and <1).
RANDARRAY
The array of random numbers between two values (>=min and <max).
RANDBETWEEN
The random integer between two values (>=bottom and <=top).
ROMAN
The text string converting a binary number to a roman numeral.
ROUND
The number rounded to a certain number of decimal places or digits.
ROUNDDOWN
The number rounded down to a certain number of decimal places or digits.
ROUNDUP
The number rounded up to a certain number of decimal places or digits.
SEC
The secant of a number.
SECH
The hyperbolic secant of a number.
SEQUENCE
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 an angle.
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 choice of 11 different operations for numerical values.
SUM
The total of the numerical values.
SUMIF
(SUMIFS) The total of the numerical values that satisfies one condition.
SUMIFS
The total of the numerical values that satisfies multiple conditions.
SUMPRODUCT
The sum of the product of one or more arrays of values.
SUMSQ
The variation of a data set from its mean.
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 an angle.
TANH
The hyperbolic tangent of a number.
TRUNC
The number truncated to a number of decimal places.

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