# Engineering Functions

- 6 minutes to read

This document briefly describes engineering functions implemented in the XtraSpreadsheet.

Name | Description | Syntax |
---|---|---|

BESSELI | Returns the modified Bessel function In(x). | BESSELI(X, N) |

BESSELJ | Calculates the Bessel function Jn(x). | BESSELJ(X, N) X is the value at which to evaluate the function. N is the order of the Bessel function. If n is not an integer, it is truncated. |

BESSELK | Returns the modified Bessel function Kn(x). | BESSELK(X, N) |

BESSELY | Returns the Bessel function Yn(x). | BESSELY(X, N) |

BIN2DEC | Converts a binary number to decimal. | BIN2DEC(number) |

BIN2HEX | Converts a binary number to hexadecimal. | BIN2HEX(number, [places]) Number is the binary number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |

BIN2OCT | Converts a binary number to octal. | BIN2OCT(number, [places]) Number is the binary number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |

BITAND | Returns a ‘Bitwise And’ of two numbers. | BITAND( number1, number2) |

BITLSHIFT | Returns a value number shifted left by shift_amount bits. | BITLSHIFT(number, shift_amount) |

BITOR | Returns a bitwise OR of 2 numbers. | BITOR(number1, number2) |

BITRSHIFT | Returns a value number shifted right by shift_amount bits. | BITRSHIFT(number, shift_amount) |

BITXOR | Returns a bitwise ‘Exclusive Or’ of two numbers. | BITXOR(number1, number2) |

COMPLEX | Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. | COMPLEX(real_num,i_num,suffix) Real_num is the real coefficient of the complex number. I_num is the imaginary coefficient of the complex number. Suffix is the suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be “i”. |

CONVERT | Converts a number from one measurement system to another. | CONVERT(number, from_unit, to_unit) Number is the number to be converted. From_unit is a text string, denoting the current unit. From_unit is a text string, denoting the unit to which the number will be cconverted. |

DEC2BIN | Converts a decimal number to binary. | DEC2BIN(number, [places]) Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |

DEC2HEX | Converts a decimal number to hexadecimal. | DEC2HEX(number, [places]) Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |

DEC2OCT | Converts a decimal number to octal. | DEC2OCT(number, [places]) Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |

DELTA | Tests whether two values are equal. | DELTA(number1, number2) |

ERF | Returns the error function integrated between lower_limit and upper_limit. | ERF(lower_limit,[upper_limit]) |

ERFC | Returns the complementary ERF function integrated between x and infinity. | ERFC(x) |

ERFC.PRECISE | Returns the complementary ERF function integrated between x and infinity. | ERFC.PRECISE(x) |

ERF.PRECISE | Returns the error function integrated between 0 and a specified limit. | ERF.PRECISE(x) |

GESTEP | Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values. | GESTEP(number,step) |

HEX2BIN | Converts a hexadecimal number to binary. | HEX2BIN(number, [places]) |

HEX2DEC | Converts a hexadecimal number to decimal | HEX2DEC(number) |

HEX2OCT | Converts a hexadecimal number to octal. | HEX2OCT(number, [places]) |

IMABS | Returns the absolute value (the modulus) of a complex number. | IMABS(inumber) |

IMAGINARY | Returns the imaginary coefficient of a complex number in x + yi or x + yj text format. | IMAGINARY(inumber) |

IMARGUMENT | Returns the argument (an angle expressed in radians) of a complex number. | IMARGUMENT(inumber) |

IMCONJUGATE | Returns the complex conjugate of a complex number in x + yi or x + yj text format. | IMCONJUGATE(inumber) |

IMCOS | Returns the cosine of a complex number | IMCOS(inumber) |

IMCOSH | Returns the hyperbolic cosine of a complex number. | IMCOSH(inumber) |

IMCOT | Returns the cotangent of a complex number. | IMCOT(inumber) |

IMCSC | Returns the cosecant of a complex number. | IMCSC(inumber) |

IMCSCH | Returns the hyperbolic cosecant of a complex number. | IMCSCH(inumber) |

IMDIV | Returns the quotient of two complex numbers in x + yi or x + yj text format. | IMDIV(inumber1,inumber2) |

IMEXP | Returns the exponential of a complex number in x + yi or x + yj text format. | IMEXP(inumber) |

IMLN | Returns the natural logarithm of a complex number in x + yi or x + yj text format. | IMLN(inumber) |

IMLOG10 | Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. | IMLOG10(inumber) |

IMLOG2 | Returns the base-2 logarithm of a complex number in x + yi or x + yj text format. | IMLOG2(inumber) |

IMPOWER | Returns a complex number raised in the specified power. | IMPOWER(inumber, number) |

IMPRODUCT | Returns the product of complex numbers in x + yi or x + yj text format. | IMPRODUCT(inumber1,inumber2,…) |

IMREAL | Returns the real coefficient of a complex number in x + yi or x + yj text format. | IMREAL(inumber) |

IMSEC | Returns the secant of a complex number. | IMSEC(inumber) |

IMSECH | Returns the hyperbolic secant of a complex number. | IMSECH(inumber) |

IMSIN | Returns the sine of a complex number in x + yi or x + yj text format. | IMSIN(inumber) |

IMSINH | Returns the hyperbolic sine of a complex number. | IMSINH(inumber) |

IMSQRT | Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. | IMSQRT(inumber) |

IMSUB | Returns the difference of two complex numbers in x + yi or x + yj text format. | IMSUB(inumber1,inumber2) |

IMSUM | Returns the sum of complex numbers. | IMSUM(inumber1, inumber2, …) |

IMTAN | Returns the tangent of a complex number. | IMTAN(number) |

OCT2BIN | Converts an octal number to binary. | OCT2BIN(number, [places]) Number is the octal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |

OCT2DEC | Converts an octal number to decimal. | OCT2DEC(number) |

OCT2HEX | Converts an octal number to hexadecimal. | OCT2HEX(number, [places]) Number is the octal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |