# 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. 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 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. BASEThe 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.MATHThe 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 (without repetition). COMBINAThe number of combinations for a given number of items (with repetition). COSThe cosine of a number. 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(Compatibility) The number rounded up to the nearest multiple of significance. EVENThe number rounded up 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(FLOOR.MATH) The number rounded down to the nearest integer or significant figure. FLOOR.MATHThe number rounded down to the nearest integer or significant figure (including 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 number of permutations for a given number of items (with duplicates). MUNITThe 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 numerical values. QUOTIENTThe integer portion after division. RADIANSThe number of radians given the number of degrees. RANDThe random number >=0 and <1. RANDARRAY(2021) 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 a specified number of digits. ROUNDUPThe number rounded up to a specified number of digits. SECThe secant of a number. SECHThe hyperbolic secant of a number. SEQUENCE(2021) 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 choice of 11 different operations for numerical values (renamed). 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 a number. TANHThe hyperbolic tangent of a number. TRUNCThe number with any decimal places removed.