BESSELI
Returns the modified Bessel function In(x).
EngineeringEngineering & Science
Engineering & Science
Engineering & Science functions support technical spreadsheets: unit conversions, complex numbers, bitwise operations, and specialized math used in STEM workflows.
This collection groups Excel functions that are commonly used for engineering & science workflows. Instead of browsing hundreds of formulas, you can focus on the exact tools that solve this type of task.
Each function page includes a short explanation and practical usage context. Use these functions as standalone tools or combine them to build more advanced, maintainable formulas.
If you frequently work with reports, dashboards, or recurring templates, bookmarking the key functions from this collection will speed up your day-to-day work.
Tips
- Start with the most common functions in this collection and expand as your problems get more complex.
- Combine these functions with structured tables to keep formulas readable and resilient.
Excel functions in this collection (54)
BESSELJ
Returns the Bessel function Jn(x).
EngineeringEngineering & Science
BESSELK
Returns the modified Bessel function Kn(x).
EngineeringEngineering & Science
BESSELY
Returns the Bessel function Yn(x).
EngineeringEngineering & Science
BIN2DEC
Converts a binary number to decimal.
EngineeringEngineering & Science
BIN2HEX
Converts a binary number to hexadecimal.
EngineeringEngineering & Science
BIN2OCT
Converts a binary number to octal.
EngineeringEngineering & Science
BITAND
Returns a 'Bitwise And' of two numbers.
EngineeringEngineering & Science
BITLSHIFT
Returns a value number shifted left by shift_amount bits.
EngineeringEngineering & Science
BITOR
Returns a bitwise OR of 2 numbers.
EngineeringEngineering & Science
BITRSHIFT
Returns a value number shifted right by shift_amount bits.
EngineeringEngineering & Science
BITXOR
Returns a bitwise 'Exclusive Or' of two numbers.
EngineeringEngineering & Science
COMPLEX
Converts real and imaginary coefficients into a complex number.
EngineeringEngineering & Science
CONVERT
Converts a number from one measurement system to another.
EngineeringEngineering & Science
DEC2BIN
Converts a decimal number to binary.
EngineeringEngineering & Science
DEC2HEX
Converts a decimal number to hexadecimal.
EngineeringEngineering & Science
DEC2OCT
Converts a decimal number to octal.
EngineeringEngineering & Science
DELTA
Tests whether two values are equal.
EngineeringEngineering & Science
ERF
Returns the error function.
EngineeringEngineering & Science
ERFC
Returns the complementary error function.
EngineeringEngineering & Science
ERFC.PRECISE
Returns the complementary ERF function integrated between x and infinity.
EngineeringEngineering & Science
ERF.PRECISE
Returns the error function.
EngineeringEngineering & Science
GESTEP
Tests whether a number is greater than a threshold value.
EngineeringEngineering & Science
HEX2BIN
Converts a hexadecimal number to binary.
EngineeringEngineering & Science
HEX2DEC
Converts a hexadecimal number to decimal.
EngineeringEngineering & Science
HEX2OCT
Converts a hexadecimal number to octal.
EngineeringEngineering & Science
IMABS
Returns the absolute value (modulus) of a complex number.
EngineeringEngineering & Science
IMAGINARY
Returns the imaginary coefficient of a complex number.
EngineeringEngineering & Science
IMARGUMENT
Returns the argument theta, an angle expressed in radians.
EngineeringEngineering & Science
IMCONJUGATE
Returns the complex conjugate of a complex number.
EngineeringEngineering & Science
IMCOS
Returns the cosine of a complex number.
EngineeringEngineering & Science
IMCOSH
Returns the hyperbolic cosine of a complex number.
EngineeringEngineering & Science
IMCOT
Returns the cotangent of a complex number.
EngineeringEngineering & Science
IMCSC
Returns the cosecant of a complex number.
EngineeringEngineering & Science
IMCSCH
Returns the hyperbolic cosecant of a complex number.
EngineeringEngineering & Science
IMDIV
Returns the quotient of two complex numbers.
EngineeringEngineering & Science
IMEXP
Returns the exponential of a complex number.
EngineeringEngineering & Science
IMLN
Returns the natural logarithm of a complex number.
EngineeringEngineering & Science
IMLOG10
Returns the base-10 logarithm of a complex number.
EngineeringEngineering & Science
IMLOG2
Returns the base-2 logarithm of a complex number.
EngineeringEngineering & Science
IMPOWER
Returns a complex number raised to an integer power.
EngineeringEngineering & Science
IMPRODUCT
Returns the product of complex numbers.
EngineeringEngineering & Science
IMREAL
Returns the real coefficient of a complex number.
EngineeringEngineering & Science
IMSEC
Returns the secant of a complex number.
EngineeringEngineering & Science
IMSECH
Returns the hyperbolic secant of a complex number.
EngineeringEngineering & Science
IMSIN
Returns the sine of a complex number.
EngineeringEngineering & Science
IMSINH
Returns the hyperbolic sine of a complex number.
EngineeringEngineering & Science
IMSQRT
Returns the square root of a complex number.
EngineeringEngineering & Science
IMSUB
Returns the difference between two complex numbers.
EngineeringEngineering & Science
IMSUM
Returns the sum of complex numbers.
EngineeringEngineering & Science
IMTAN
Returns the tangent of a complex number.
EngineeringEngineering & Science
OCT2BIN
Converts an octal number to binary.
EngineeringEngineering & Science
OCT2DEC
Converts an octal number to decimal.
EngineeringEngineering & Science
OCT2HEX
Converts an octal number to hexadecimal.
EngineeringEngineering & Science