Engineering Functions

• Nov 15, 2022
• 6 minutes to read

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

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 number shifted left by the specified number of bits.	BITLSHIFT(number, shift_amount)
BITOR	Returns a bitwise ‘OR’ of two numbers.	BITOR(number1, number2)
BITRSHIFT	Returns a number shifted right by the specified number of bits.	BITRSHIFT(number, shift_amount)
BITXOR	Returns a bitwise ‘XOR’ 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.	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]) 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.
HEX2DEC	Converts a hexadecimal number to decimal.	HEX2DEC(number)
HEX2OCT	Converts a hexadecimal number to octal.	HEX2OCT(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.
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 theta (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 raised to a power.	IMPOWER(inumber, number)
IMPRODUCT	Returns the product of 1 to 255 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 square root 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 two or more 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.