Wednesday, November 10, 2021

Engineering functions reference

To get detailed information about a function, click its name in the first column.

Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.

Function

Description

BESSELI function

Returns the modified Bessel function In(x)

BESSELJ function

Returns the Bessel function Jn(x)

BESSELK function

Returns the modified Bessel function Kn(x)

BESSELY function

Returns the Bessel function Yn(x)

BIN2DEC function

Converts a binary number to decimal

BIN2HEX function

Converts a binary number to hexadecimal

BIN2OCT function

Converts a binary number to octal

BITAND function
Excel 2013

Returns a bitwise 'And' of two numbers

BITLSHIFT function
Excel 2013

Returns a number shifted left by shift_amount bits

BITOR function
Excel 2013

Returns a bitwise 'Or' of two numbers

BITRSHIFT function
Excel 2013

Returns a number shifted right by shift_amount bits

BITXOR function
Excel 2013

Returns a bitwise 'Exclusive Or' of two numbers

COMPLEX function

Converts real and imaginary coefficients into a complex number

CONVERT function

Converts a number from one measurement system to another

DEC2BIN function

Converts a decimal number to binary

DEC2HEX function

Converts a decimal number to hexadecimal

DEC2OCT function

Converts a decimal number to octal

DELTA function

Tests whether two values are equal

ERF function

Returns the error function

ERF.PRECISE function
Excel 2010

Returns the error function

ERFC function

Returns the complementary error function

ERFC.PRECISE function
Excel 2010

Returns the complementary ERF function integrated between x and infinity

GESTEP function

Tests whether a number is greater than a threshold value

HEX2BIN function

Converts a hexadecimal number to binary

HEX2DEC function

Converts a hexadecimal number to decimal

HEX2OCT function

Converts a hexadecimal number to octal

IMABS function

Returns the absolute value (modulus) of a complex number

IMAGINARY function

Returns the imaginary coefficient of a complex number

IMARGUMENT function

Returns the argument theta, an angle expressed in radians

IMCONJUGATE function

Returns the complex conjugate of a complex number

IMCOS function

Returns the cosine of a complex number

IMCOSH function
Excel 2013

Returns the hyperbolic cosine of a complex number

IMCOT function
Excel 2013

Returns the cotangent of a complex number

IMCSC function
Excel 2013

Returns the cosecant of a complex number

IMCSCH function
Excel 2013

Returns the hyperbolic cosecant of a complex number

IMDIV function

Returns the quotient of two complex numbers

IMEXP function

Returns the exponential of a complex number

IMLN function

Returns the natural logarithm of a complex number

IMLOG10 function

Returns the base-10 logarithm of a complex number

IMLOG2 function

Returns the base-2 logarithm of a complex number

IMPOWER function

Returns a complex number raised to an integer power

IMPRODUCT function

Returns the product of from 2 to 255 complex numbers

IMREAL function

Returns the real coefficient of a complex number

IMSEC function
Excel 2013

Returns the secant of a complex number

IMSECH function
Excel 2013

Returns the hyperbolic secant of a complex number

IMSIN function

Returns the sine of a complex number

IMSINH function
Excel 2013

Returns the hyperbolic sine of a complex number

IMSQRT function

Returns the square root of a complex number

IMSUB function

Returns the difference between two complex numbers

IMSUM function

Returns the sum of complex numbers

IMTAN function
Excel 2013

Returns the tangent of a complex number

OCT2BIN function

Converts an octal number to binary

OCT2DEC function

Converts an octal number to decimal

OCT2HEX function

Converts an octal number to hexadecimal

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Excel functions (by category)

Excel functions (alphabetical)

No comments:

Post a Comment