Use Excel's math and trigonometry functions in your Anaplan XL reports
| Function | Description |
| ABS | Returns the absolute value of a number. |
| ACOS | Returns the arccosine of a number in radians in the range 0 to pi. |
| ACOSH | Returns the inverse hyperbolic cosine of a number. |
| ACOT | Returns the inverse cotangent of the specified number. |
| ACOTH | Returns the inverse hyperbolic cotangent of the specified number. |
| AGGREGATE | Returns an aggregate in a list or database |
| ARABIC | Converts the specified Roman numeral to a number. |
| ASIN | Returns the arcsine of a number in radians in the range -pi/2 to pi/2. |
| ASINH | Returns the inverse hyperbolic sine of a number. |
| ATAN | Returns the arctangent of a number in radians in the range -pi/2 to pi/2 |
| ATAN2 | Returns the four-quadrant arctangent of the specified x- and y- coordinates in radians between -pi and pi excluding -pi. A positive result represents a counterclockwise angle from the x-axis, a negative result represents a clockwise angle. |
| ATANH | Returns the inverse hyperbolic tangent of a number. |
| BASE | Converts the specified number to text with the specified radix and minimum length. |
| CEILING | Returns a number rounded up, away from zero, to the nearest multiple of significance. |
| CEILING.MATH | Returns the specified number rounded up using the specified significance and mode. |
| CEILING.PRECISE | Rounds a number to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number if rounded up. |
| COMBIN | Returns the number of combinations for a given number of items. |
| COMBINA | Returns the number of combinations with the specified number of items. |
| COS | Returns the cosine of the given angle. |
| COSH | Returns the hyperbolic cosine of a number. |
| COT | Returns the cotangent of the specified angle. |
| COTH | Returns the hyperbolic cotangent of the specified angle. |
| CSC | Returns the cosecant of the specified angle. |
| CSCH | Returns the hyperbolic cosecant of the specified angle. |
| DECIMAL | Converts the specified text to a number using the specified radix. |
| DEGREES | Converts radians into degrees. |
| EVEN | Returns a number rounded up to the next even integer for positive integers and rounded down to the next even integer for negative numbers. |
| EXP | Returns e (2.71828182845804) raised to the power of a specified number. |
| FACT | Returns the factorial of a number. |
| FACTDOUBLE | Returns the double factorial of a number. |
| FLOOR | Returns a number rounded down, toward zero, to the nearest multiple of significance. |
| FLOOR.MATH | Returns the specified number rounded down using the specified significance and mode. |
| FLOOR.PRECISE | Rounds a number to the nearest integeror to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. |
| GCD | Returns the greatest common divisor of two or more integers. |
| INT | Rounds a number down to the nearest integer. |
| ISO.CEILING | Returns the specified number rounded up using the specified significance. |
| LCM | Returns the least common multiple of integers. |
| LN | Returns the natural (base e) logarithm of a number. |
| LOG | Returns the logarithm of a number of the base you specify. |
| LOG10 | Returns the base-10 logarithm of a number. |
| MDETERM | Returns the matrix determinant of an array. |
| MINVERSE | Returns the inverse matrix for the matrix stored in an array. |
| MMULT | Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. |
| MOD | Returns the remainder of a division operation (modulus). |
| MROUND | Returns a number rounded to the desired multiple. Rounds up if the remainder after dividing the number by the multiple is at least half the value of the multiple. |
| MULTINOMIAL | Returns the ratio of the factorial of the sum of the values to the product of the factorials. |
| MUNIT | Returns an identity matrix with the specified n by n dimension. |
| ODD | Returns a number rounded up away from zero to the nearest odd integer. |
| PI | Returns the approximate number 3.14159265358979, the mathematical constant pi, accurate to 15 digits. |
| POWER | Returns the result of a specified number raised to a specified power. |
| PRODUCT | Multiplies all the numbers given as arguments and returns the product. |
| QUOTIENT | Returns the integer portion of a division. |
| RADIANS | Converts degrees to radians. |
| RAND | Returns an evenly distributed random number greater than or equal to 0 and less than 1. A new random number is returned every time the worksheet is calculated. |
| RANDBETWEEN | Returns a random integer between the integers you specify. A new random number is returned every time the worksheet is calculated. |
| ROMAN | Converts an Arabic numeral to Roman, as text. |
| ROUND | Round a number to a specified number of digits. |
| ROUNDDOWN | Rounds a number down, towards zero. |
| ROUNDUP | Rounds a number up, away from zero. |
| SEC | Returns the secant of the specified angle. |
| SECH | Returns the hyperbolic secant of the specified angle. |
| SERIESSUM | Returns the sum of a power series. |
| SIGN | Determines the sign of a number. Returns 1 if the value is positive, 0 if the value is 0, and -1 if the value is negative. |
| SIN | Returns the sine of a given angle. |
| SINH | Returns the hyperbolic sine of a number. |
| SQRT | Returns a positive square root. |
| SQRTPI | Returns the square root of (NUMBER * Pi) |
| SUBTOTAL | Returns a subtotal in a list or database. |
| SUM | Adds all the numbers in a range of cells. |
| SUMIF | Adds the cells specified by a certain criteria. |
| SUMIFS | Adds the cells in a range that meet multiple criteria |
| SUMPRODUCT | Multiplies corresponding components in the given arrays, and returns the sum of those products. |
| SUMSQ | Returns the sum of the squares of the arguments. |
| SUMX2MY2 | Returns the sum of the difference of squares of corresponding values in two arrays. |
| SUMX2PY2 | Returns the sum of the sum of squares of corresponding values in two arrays. |
| SUMXMY2 | Returns the sum of squares of differences of corresponding values in two arrays. |
| TAN | Returns the tangent of the given angle. |
| TANH | Returns the hyperbolic tangent of a number. |
| TRUNC | Truncates a number to an integer by removing the fractional part of a number. |
