Skip to main content

Math and trig functions

NameDescriptionSyntax
ABSReturns the number without its sign (absolute value)ABS(value)
ACOSReturns the arccosine of a numberACOS(value)
ACOSHReturns the inverse hyperbolic cosine of a numberACOSH(value)
ACOTReturns the arccotangent of a numberACOT(value)
ASINReturns the arcsine of a numberASIN(value)
ATANReturns the arctangent of a numberATAN(value)
ATAN2Returns the arctangent of the specified coordinates, which is the angle between the X-axis and a line from the origin to the required pointATAN2(x, y)
ATANHCalculates the inverse hyperbolic tangent for a number.ATANH(value)
COSHReturns the hyperbolic cosine of a numberCOSH(value)
COTHReturns the hyperbolic cotangent of a numberCOTH(value)
CSCReturns the cosecant of the angle specified in radians.CSC(angle)
CSCHReturns the hyperbolic cosecant of a numberCSCH(value)
EXPRaises the constant e (approximately equal to 2.718) to a specified powerEXP(power)
LNReturns the natural logarithm of a number. Base is the constant e, approximately equal to 2.718LN(value)
LOGReturns the logarithm of a number to a given baseLOG(value, [base])
LOG10Returns the logarithm of a number to the base 10LOG10(value)
SECReturns the secant of an angleSEC(angle)
SECHReturns the hyperbolic secant of a numberSECH(value)
SINHReturns the hyperbolic sine of a numberSINH(value)
TANHReturns the hyperbolic tangent of a numberTANH(value)
DEGREESReturns an angle value in degreesDEGREES(angle)
FACTDOUBLEReturns the double factorial of a numberFACTDOUBLE(value)
SQRTReturns the square root of a numberSQRT(value)
SQRTPIReturns the square root of the product of π (3.1415…) and a specified valueSQRTPI(value)
ROUNDRounds a value to a specified number of places before or after the decimal pointROUND(value, places)
ROUNDUPRounds a value up to a specified number of places before or after the decimal pointROUNDUP(value, places)
ROUNDDOWNRounds a value down to a specified number of places before or after the decimal pointROUNDDOWN(value, places)
PIReturns the number π accurate to 10 digits after the decimal pointPI()
PRODUCTReturns the product of all valuesPRODUCT(value1, [value2, ...])
SUBTOTALReturns subtotals for a range of numbers applying another functionSUBTOTAL( function_code, range1, [range2, ...])
RANDReturns a random decimal number that is greater than or equal to 0 and less than 1RAND()
POWERRaises a number to a specified powerPOWER(value, power)
SUMReturns the sum of all valuesSUM(value1, [value2, ... ])
SUMIFReturns the sum of the values that meet the given criterionSUMIF(range, criterion, [sum_range])
SUMIFSAdds range values that meet all specified criteriaSUMIFS(sum_range, criterion_range1, criterion1, [criterion_range2, criterion2, ...])
SUMSQReturns the sum of the squares of all valuesSUMSQ(value1, [value2, ... ])
SUMPRODUCTReturns the sum of products of corresponding values in arrays or rangesSUMPRODUCT(array1, [array2, ...])
FACTReturns the factorial of a numberFACT(value)
INTRounds a number down to the nearest integerINT(value)
QUOTIENTReturns the integer part of a divisionQUOTIENT(dividend, divisor)