Engineering Functions
BESSELI function
Returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments.
BESSELJ function
Returns the Bessel function.
BESSELK function
Returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments.
BESSELY function
Returns the Bessel function, which is also called the Weber function or the Neumann function.
BIN2DEC function
Converts a binary number into a decimal number.
BIN2HEX function
Converts a binary number into a hexadecimal number.
BIN2OCT function
Converts a binary number into an octal number.
BITAND function
Returns a bitwise 'AND' of two numbers.
BITLSHIFT function
Returns a number shifted left by the specified number of bits.
BITOR function
Returns a bitwise 'OR' of two numbers.
BITRSHIFT function
Returns a number shifted right by the specified number of bits.
BITXOR function
Returns a bitwise 'XOR' of two numbers.
COMPLEX function
Converts a real part and an imaginary part into a complex number expressed in a + bi or a + bj form.
CONVERT function
Converts a number from one measurement system to another.
DEC2BIN function
Converts a decimal number into a binary number.
DEC2HEX function
Converts a decimal number into a hexadecimal number.
DEC2OCT function
Converts a decimal number into an octal number.
DELTA function
Tests if two numbers are equal and returns 1 if they are equal and 0 otherwise.
ERF function
Calculates the error function integrated between the specified lower and upper limits.
ERF.PRECISE function
Returns the error function integrated between 0 and the specified lower limit.
ERFC function
Calculates the complementary error function integrated between the specified lower limit and infinity.
ERFC.PRECISE function
Calculates the complementary error function integrated between the specified lower limit and infinity.
GESTEP function
Tests if a number is greater than or equal to a threshold value and returns 1 if it is and 0 otherwise.
HEX2BIN function
Converts a hexadecimal number to a binary number.
HEX2DEC function
The HEX2DEC function converts a hexadecimal number into a decimal number.
HEX2OCT function
The HEX2OCT function converts a hexadecimal number to an octal number.
IMABS function
The IMABS function returns the absolute value of a complex number.
IMAGINARY function
The IMAGINARY function returns the imaginary part of the specified complex number.
IMARGUMENT function
The IMARGUMENT function returns the argument Theta, an angle expressed in radians.
IMCONJUGATE function
The IMCONJUGATE function returns the complex conjugate of a complex number.
IMCOS function
The IMCOS function returns the cosine of a complex number.
IMCOSH function
The IMCOSH function returns the hyperbolic cosine of a complex number.
IMCOT function
The IMCOT function returns the cotangent of a complex number.
IMCSC function
The IMCSC function returns the cosecant of a complex number.
IMCSCH function
The IMCSCH function returns the hyperbolic cosecant of a complex number.
IMDIV function
The IMDIV function returns the quotient of two complex numbers expressed in x + yi or x + yj form.
IMEXP function
The IMEXP function returns the e constant raised to the power specified by a complex number.
IMLN function
The IMLN function returns the natural logarithm of a complex number.
IMLOG10 function
The IMLOG10 function returns the logarithm of a complex number to a base of 10.
IMLOG2 function
The IMLOG2 function returns the logarithm of a complex number to a base of 2.
IMPOWER function
The IMPOWER function returns the result of a complex number raised to the desired power.
IMPRODUCT function
The IMPRODUCT function returns the product of the specified complex numbers.
IMREAL function
The IMREAL function returns the real part of the specified complex number.
IMSEC function
The IMSEC function returns the secant of a complex number.
IMSECH function
The IMSECH function returns the hyperbolic secant of a complex number.
IMSIN function
The IMSIN function returns the sine of a complex number.
IMSINH function
The IMSINH function returns the hyperbolic sine of a complex number.
IMSQRT function
The IMSQRT function returns the square root of a complex number.
IMSUB function
The IMSUB function returns the difference of two complex numbers expressed in x + yi or x + yj form.
IMSUM function
The IMSUM function returns the sum of the specified complex numbers.
IMTAN function
The IMTAN function returns the tangent of a complex number.
OCT2BIN function
The OCT2BIN function converts an octal number to a binary number.
OCT2DEC function
The OCT2DEC function converts an octal number to a decimal number.
OCT2HEX function
The OCT2HEX function converts an octal number to a hexadecimal number.