Use Excel's engineering functions in your Anaplan XL reports.
| Function | Description |
| BESSELI | Returns the BESSEL function in modified form for imaginary arguments. |
| BESSELJ | Returns the actual BESSEL function. |
| BESSELK | Returns the BESSEL function in modified form for imaginary arguments. |
| BESSELY | Returns the BESSEL function, also known as the Weber or Neumann function. |
| BIN2DEC | Converts a binary number to decimal form. |
| BIN2HEX | Converts a binary number to a hexadecimal. |
| BIN2OCT | Converts a binary number to octal form. |
| BITAND | Returns the bitwise AND of the two specified numbers. |
| BITLSHIFT | Returns the specified number shifted left by the specified amount. |
| BITOR | Returns the bitwise OR of the two specified numbers. |
| BITRSHIFT | Returns the specified number shifted right by the specified amount. |
| BITXOR | Returns the bitwise XOR of the two specified numbers. |
| COMPLEX | Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. |
| CONVERT | Interprets data from one measurement system to another. |
| DEC2BIN | Converts decimal numbers to binary form. |
| DEC2HEX | Converts decimal numbers to hexadecimal. |
| DEC2OCT | Converts decimal numbers to octal. |
| DELTA | Tests whether numbers or values are equal to a number result. Returns "0" for unequal, "1" for equal. |
| ERF | Returns the integrated error function between a lower and upper limit. |
| ERF.PRECISE | Returns the error function |
| ERFC | Returns a complementary ERF function integrated between 'x' and infinity. |
| ERFC.PRECISE | Returns the complementary ERF function integrated between x and infinity |
| GESTEP | Returns the value 1 if the number is greater than or equal to a specified step value, otherwise it returns 0. |
| HEX2BIN | Converts hexadecimal numbers to binary form. |
| HEX2DEC | Converts hexadecimal numbers to decimal form. |
| HEX2OCT | Converts hexadecimal numbers to octal form. |
| IMABS | Returns the absolute value (modulus) of a complex number in x+yi or x+yj text format. |
| IMAGINARY | Returns the coefficient of a complex number in x+yi or x+yj text format. |
| IMARGUMENT | Returns the theta argument - an angle expressed in radians. |
| IMCONJUGATE | Returns the complex conjugate of a complex number in x+yi or x+yj text format. |
| IMCOS | Returns the cosine of a complex number in x+yi or x+yj text format. |
| IMCOSH | Returns the hyperbolic cosine of the specified complex number. |
| IMCOT | Returns the cotangent of the specified complex number. |
| IMCSC | Returns the cosecant of the specified complex number. |
| IMCSCH | Returns the hyperbolic cosecant of the specified complex number. |
| IMDIV | Returns the quotient of complex numbers in x+yi or x+yj text format. |
| IMEXP | Returns the exponential of a complex number in x+yi or x+yj text format. |
| IMLN | Returns the natural logarithm of a complex number in x+yi or x+yj text format. |
| IMLOG10 | Returns the common logarithm (Base 10) of a complex number in x+yi or x+yj text format. |
| IMLOG2 | Returns the common logarithm (Base 2) of a complex number in x+yi or x+yj text format. |
| IMPOWER | Returns a complex number raised to a power in x+yi or x+yj text format. |
| IMPRODUCT | Returns the product from 2 to 29 complex numbers in x+yi or x+yj text format. |
| IMREAL | Returns the real coefficient of a complex number in x+yi or x+yj text format. |
| IMSEC | Returns the secant of the specified complex number. |
| IMSECH | Returns the hyperbolic secant of the specified complex number. |
| IMSIN | Returns the sine of a complex number in x+yi or x+yj text format. |
| IMSINH | Returns the hyperbolic sine of the specified complex number. |
| IMSQRT | Returns the square root of a complex number in x+yi or x+yj text format. |
| IMSUB | Returns the difference of two complex numbers in x+yi or x+yj text format. |
| IMSUM | Returns the sum of 2 to 29 complex numbers in x+yi or x+yj text format. |
| IMTAN | Returns the tangent of the specified complex number. |
| OCT2BIN | Converts an octal number to binary form. |
| OCT2DEC | Converts an octal number to decimal form. |
| OCT2HEX | Converts an octal number to hexadecimal form. |
