Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

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

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.

See Also

Excel functions (by category)

Excel functions (alphabetical)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.