# Engineering Functions

- 6 minutes to read

This document describes engineering functions supported by the WPF Spreadsheet control.

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

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

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. | |

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

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

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

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. | |

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. | |

Returns a bitwise ‘AND’ of two numbers. | BITAND( number1, number2) | |

Returns a number shifted left by the specified number of bits. | BITLSHIFT(number, shift_amount) | |

Returns a bitwise ‘OR’ of two numbers. | BITOR(number1, number2) | |

Returns a number shifted right by the specified number of bits. | BITRSHIFT(number, shift_amount) | |

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

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”. | |

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. | |

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. | |

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. | |

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. | |

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

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

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

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

Returns the error function. | ERF.PRECISE(x) | |

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Returns a complex number raised raised to a power. | IMPOWER(inumber, number) | |

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

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

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

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

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

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

Returns the square root of a complex number in x + yi or x + yj text format. | IMSQRT(inumber) | |

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

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

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

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. | |

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

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. |