Math and trigonometry functions

Functions in EnglishFunctions in FrenchDescription of Function
ABSABSReturns the absolute value of a number.
ACOSACOSReturns the arccosine of a number.
ACOSHACOSHReturns the inverse hyperbolic cosine of a number.
ACOTACOTReturns the arccotangent of a number (2013).
ACOTHACOTHReturns the hyperbolic arccotangent of a number (2013).
AGGREGATEAGREGATReturns an aggregate in a list or database.
ARABICARABEConverts a Roman number to Arabic, as a number (2013).
ASINASINReturns the arcsine of a number.
ASINHASINHReturns the inverse hyperbolic sine of a number.
ATANATANReturns the arctangent of a number.
ATAN2ATAN2Returns the arctangent from x- and y-coordinates.
ATANHATANHReturns the inverse hyperbolic tangent of a number.
BASEBASEConverts a number into a text representation with the given radix (base) (2013).
CEILINGPLAFONDRounds a number to the nearest integer or to the nearest multiple of significance.
CEILING.MATHPLAFOND.MATHRounds a number up, to the nearest integer or to the nearest multiple of significance (2013).
CEILING.PRECISEPLAFOND.PRECISRounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up..
COMBINCOMBINReturns the number of combinations for a given number of objects.
COMBINACOMBINAReturns the number of combinations with repetitions for a given number of items (2013).
COSCOSReturns the cosine of a number.
COSHCOSHReturns the hyperbolic cosine of a number.
COTCOTReturns the hyperbolic cosine of a number (2013).
COTHCOTHReturns the cotangent of an angle (2013).
CSCCSCReturns the cosecant of an angle (2013).
CSCHCSCHReturns the hyperbolic cosecant of an angle (2013).
DECIMALDECIMALConverts a text representation of a number in a given base into a decimal number (2013).
DEGREESDEGRESConverts radians to degrees.
EVENPAIRRounds a number up to the nearest even integer.
EXPEXPReturns e raised to the power of a given number.
FACTFACTReturns the factorial of a number.
FACTDOUBLEFACTDOUBLEReturns the double factorial of a number.
FLOORPLANCHERRounds a number down, toward zero.
FLOOR.MATHPLANCHER.MATHRounds a number down, to the nearest integer or to the nearest multiple of significance (2013).
FLOOR.PRECISEPLANCHER.PRECISRounds a numer down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down..
GCDPGCDReturns the greatest common divisor.
INTENTRounds a number down to the nearest integer.
LCMPPCMReturns the least common multiple.
LNLNReturns the natural logarithm of a number.
LOGLOGReturns the logarithm of a number to a specified base.
LOG10LOG10Returns the base-10 logarithm of a number.
MDETERMDETERMATReturns the matrix determinant of an array.
MINVERSEINVERSEMATReturns the matrix inverse of an array.
MMULTPRODUITMATReturns the matrix product of two arrays.
MODMODReturns the remainder from division.
MROUNDARRONDI.AU.MULTIPLEReturns a number rounded to the desired multiple.
MULTINOMIALMULTINOMIALEReturns the multinomial of a set of numbers.
MUNITMATRICE.UNITAIREReturns the unit matrix or the specified dimension (2013).
ODDIMPAIRRounds a number up to the nearest odd integer.
PIPIReturns the value of pi.
POWERPUISSANCEReturns the result of a number raised to a power.
PRODUCTPRODUITMultiplies its arguments.
QUOTIENTQUOTIENTReturns the integer portion of a division.
RADIANSRADIANSConverts degrees to radians.
RANDALEAReturns a random number between 0 and 1.
RANDBETWEENALEA.ENTRE.BORNESReturns a random number between the numbers you specify.
ROMANROMAINConverts an arabic numeral to roman, as text.
ROUNDARRONDIRounds a number to a specified number of digits.
ROUNDDOWNARRONDI.INFRounds a number down, toward zero.
ROUNDUPARRONDI.SUPRounds a number up, away from zero.
SECSECReturns the secant of an angle (2013).
SECHSECHReturns the hyperbolic secant of an angle (2013).
SERIESSUMSOMME.SERIESReturns the sum of a power series based on the formula.
SIGNSIGNEReturns the sign of a number.
SINSINReturns the sine of the given angle.
SINHSINHReturns the hyperbolic sine of a number.
SQRTRACINEReturns a positive square root.
SQRTPIRACINE.PIReturns the square root of (number * pi).
SUBTOTALSOUS.TOTALReturns a subtotal in a list or database.
SUMSOMMEAdds its arguments.
SUMIFSOMME.SIAdds the cells specified by a given criteria.
SUMIFSSOMME.SI.ENSAdds the cells in a range that meet multiple criteria.
SUMPRODUCTSOMMEPRODReturns the sum of the products of corresponding array components.
SUMSQSOMME.CARRESReturns the sum of the squares of the arguments.
SUMX2MY2SOMME.X2MY2Returns the sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2SOMME.X2PY2Returns the sum of the sum of squares of corresponding values in two arrays.
SUMXMY2SOMME.XMY2Returns the sum of squares of differences of corresponding values in two arrays.
TANTANReturns the tangent of a number.
TANHTANHReturns the hyperbolic tangent of a number.
TRUNCTRONQUETruncates a number to an integer.