### 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. AGGREGATEThe 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(365 Insiders) 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(365 Insiders) 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.