Engineering Functions

Engineering and technical functions

BESSELI Function

The BESSELI function computes the modified Bessel function of the first kind, essential for engineering analysis involving wave propagation, heat transfer, and vibration problems. It evaluates the Bessel function for purely imaginary arguments, providing real-valued results for complex physical modeling.

BESSELJ Function

The Excel BESSELJ function calculates the Bessel function of the first kind for a specified order and value. This advanced mathematical function is essential for engineering applications involving wave propagation, vibration analysis, and heat conduction problems.

BESSELK Function

The BESSELK function computes the modified Bessel function of the second kind, useful in engineering applications like heat transfer, vibration analysis, and wave propagation problems. It evaluates Bessel functions for purely imaginary arguments.

BESSELY Function

The BESSELY function calculates the Bessel function of the second kind, also known as Weber's or Neumann's function. This advanced mathematical function is essential for engineering calculations involving wave propagation, vibration analysis, and heat conduction problems.

BIN2DEC Function

The Excel BIN2DEC function converts a binary number to its decimal equivalent. It handles both positive and negative binary numbers using two's-complement notation for signed values.

BIN2HEX Function

The BIN2HEX function converts binary numbers to their hexadecimal equivalents, supporting both positive and negative values through two's-complement representation. Ideal for bitwise operations and number system conversions in Excel.

BIN2OCT Function

The Excel BIN2OCT function converts a binary number to its octal (base-8) equivalent. It handles both positive and negative binary numbers using two's complement notation, making it essential for number system conversions in technical calculations.

BITAND Function

The Excel BITAND function performs a bitwise AND operation between two decimal numbers, returning a decimal result where each bit is set only if corresponding bits in both input numbers are 1. Perfect for low-level binary manipulation and flag checking in Excel.

BITLSHIFT Function

The BITLSHIFT function performs a left binary shift on a number by the specified number of bits, effectively multiplying the number by 2 raised to the power of the shift amount. This is a powerful bitwise operation for advanced numerical computations in Excel.

BITOR Function

The Excel BITOR function performs a bitwise OR operation between two decimal numbers, returning a new number where each bit position is set to 1 if either of the input numbers has a 1 in that position. This powerful function enables precise binary manipulation directly within Excel spreadsheets.

BITRSHIFT Function

The BITRSHIFT function performs a bitwise right shift operation on a number, effectively dividing it by powers of 2 while discarding the remainder bits. This is useful for integer division by powers of 2 and binary manipulation tasks.

BITXOR Function

The BITXOR function performs a bitwise Exclusive OR operation between two numbers, returning a decimal result where each bit is set to 1 only when the corresponding bits in the input numbers differ.

COMPLEX Function

The Excel COMPLEX function converts real and imaginary coefficients into a proper complex number representation in the form x + yi or x + yj, enabling mathematical operations with complex numbers in spreadsheets.

CONVERT Function

The Excel CONVERT function transforms numeric values between different measurement systems, enabling seamless unit conversions across distance, weight, temperature, volume, and many other categories. Perfect for international data analysis and scientific calculations.

DEC2BIN Function

The Excel DEC2BIN function converts decimal integers to their binary representation. It handles both positive numbers (0 to 511) and negative numbers (-512 to -1) using two's complement notation for negatives.

DEC2HEX Function

The DEC2HEX function converts decimal numbers to their hexadecimal representation. It handles both positive and negative integers, with special two's-complement notation for negatives, making it essential for binary data analysis, programming, and low-level computing tasks.

DEC2OCT Function

The Excel DEC2OCT function converts decimal numbers to their octal (base-8) representation. This is particularly useful for programmers working with binary data, embedded systems developers, or anyone needing to display numbers in octal format for analysis or documentation purposes.

DELTA Function

The DELTA function tests whether two numbers are equal, returning 1 for exact matches and 0 otherwise. Known as the Kronecker Delta in mathematics, it's perfect for filtering datasets, counting matches, and creating conditional indicators in Excel analysis.

ERF Function

The Excel ERF function calculates the error function, which is the integral of the Gaussian distribution between specified limits. This statistical function is essential for probability calculations, confidence intervals, and scientific computations involving normal distributions.

ERF.PRECISE Function

The ERF.PRECISE function calculates the error function integrated between 0 and a specified lower bound value. This advanced statistical function is essential for probability calculations, heat conduction analysis, and other scientific applications requiring precise error function values.

ERFC Function

The ERFC function calculates the complementary error function, which represents the area under the Gaussian curve from a given value x to infinity. This statistical function is essential for probability calculations, confidence intervals, and advanced data analysis.

ERFC.PRECISE Function

The ERFC.PRECISE function calculates the complementary error function, which is the integral of the Gaussian error function from a specified value x to infinity. This statistical function is essential for precise probability calculations in advanced data analysis.

GESTEP Function

The GESTEP function in Excel returns 1 if a specified number meets or exceeds a threshold value, otherwise returns 0. This makes it perfect for creating custom filters, counting values above certain limits, and building conditional logic without complex IF statements.

HEX2BIN Function

The Excel HEX2BIN function converts hexadecimal numbers to their binary representation. It handles both positive and negative numbers using two's-complement notation, making it essential for binary data analysis and low-level programming tasks.

HEX2DEC Function

The Excel HEX2DEC function converts hexadecimal numbers to their decimal equivalents, supporting both positive and negative values through two's complement notation. Perfect for binary data analysis, programming conversions, and engineering calculations.

HEX2OCT Function

The Excel HEX2OCT function converts hexadecimal numbers to their octal (base-8) equivalents. This is essential for number system conversions, particularly when working with binary data representations or legacy systems that use octal notation.

IMABS Function

The Excel IMABS function calculates the absolute value (modulus) of a complex number expressed in standard x + yi or x + yj format. This engineering function extracts the magnitude from complex numbers used in electrical engineering, physics, and mathematical computations.

IMAGINARY Function

The Excel IMAGINARY function extracts the imaginary coefficient from a complex number expressed in x + yi or x + yj format. It returns the 'y' value from a complex number, making it essential for complex number arithmetic and engineering calculations.

IMARGUMENT Function

The Excel IMARGUMENT function extracts the angle (theta) in radians from a complex number, representing its argument in the complex plane. This engineering function is essential for complex number analysis, phase calculations, and mathematical computations involving polar forms.

IMCONJUGATE Function

The Excel IMCONJUGATE function returns the complex conjugate of a complex number provided in x+yi or x+yj format. This mathematical operation flips the sign of the imaginary component while keeping the real part unchanged.

IMCOS Function

The Excel IMCOS function calculates the cosine of a complex number, essential for advanced mathematical and engineering calculations involving complex arguments. It returns results in standard complex number format (x+yi).

IMCOSH Function

The Excel IMCOSH function calculates the hyperbolic cosine of a complex number entered in x+yi or x+yj format. This engineering function handles complex mathematical computations that standard COSH cannot process.

IMCOT Function

The Excel IMCOT function calculates the cotangent of a complex number entered in x+yi or x+yj format. This trigonometric function handles complex number mathematics that standard COT cannot process.

IMCSC Function

The Excel IMCSC function calculates the cosecant of a complex number, returning the result in standard complex number format (x+yi). This trigonometric function is essential for advanced mathematical computations involving complex arguments.

IMCSCH Function

The Excel IMCSCH function calculates the hyperbolic cosecant of a complex number entered in standard x+yi or x+yj format. This advanced mathematical function is essential for engineering and scientific computations involving complex hyperbolic trigonometry.

IMDIV Function

The Excel IMDIV function calculates the quotient (result of division) between two complex numbers expressed in x+yi format. It performs complex number division and returns the result as a complex number in standard rectangular form.

IMEXP Function

The Excel IMEXP function calculates the exponential (e^z) of a complex number z in the form x + yi. This engineering function is essential for advanced mathematical computations involving complex exponentials, commonly used in electrical engineering, signal processing, and physics.

IMLN Function

The Excel IMLN function calculates the natural logarithm of a complex number provided in x+yi or x+yj text format. This engineering function returns results as complex numbers, making it essential for advanced mathematical computations involving imaginary values.

IMLOG10 Function

The Excel IMLOG10 function computes the base-10 logarithm of a complex number entered in standard x+yi format. This engineering function returns results as complex numbers, enabling logarithmic calculations on numbers with both real and imaginary components.

IMLOG2 Function

The Excel IMLOG2 function calculates the base-2 logarithm of a complex number entered in standard x+yi format. This engineering function is essential for complex number calculations in fields like electrical engineering and signal processing.

IMPOWER Function

The Excel IMPOWER function calculates a complex number raised to a specified power, returning the result in standard complex number format (x + yi). This engineering function handles both integer and fractional exponents for complex values.

IMPRODUCT Function

The Excel IMPRODUCT function multiplies 1 to 255 complex numbers together, returning the product in standard complex number format (x+yi). Essential for complex mathematical calculations in engineering, physics, and signal processing applications.

IMREAL Function

The Excel IMREAL function extracts the real coefficient from a complex number expressed in x+yi or x+yj format. It provides a straightforward way to isolate the real part of complex mathematical expressions used in engineering and scientific calculations.

IMSEC Function

The Excel IMSEC function calculates the secant of a complex number expressed in x+yi or x+yj format. This advanced mathematical function is essential for complex analysis and engineering calculations involving hyperbolic trigonometry.

IMSECH Function

The Excel IMSECH function calculates the hyperbolic secant of a complex number, returning the result in standard complex number format (x+yi). This advanced mathematical function is essential for engineering calculations and complex analysis.

IMSIN Function

The Excel IMSIN function calculates the sine of a complex number provided in x+yi or x+yj format. This engineering function is essential for advanced mathematical computations involving complex numbers.

IMSINH Function

The IMSINH function computes the hyperbolic sine of a complex number provided in x+yi or x+yj format. This advanced mathematical function is essential for engineering calculations and scientific analysis involving complex numbers.

IMSQRT Function

The IMSQRT function calculates the square root of a complex number provided in x+yi or x+yj format. This engineering function handles mathematical operations on complex numbers that Excel's standard SQRT cannot process.

IMSUB Function

The IMSUB function subtracts one complex number from another, returning the result in standard complex number format (x + yi). Perfect for engineering calculations, electrical engineering, and scientific applications requiring complex arithmetic.

IMSUM Function

The IMSUM function adds two or more complex numbers together, handling both real and imaginary components. Complex numbers are expressed in Excel as text strings in the format 'x+yi' or 'x+yj' where x is the real part and y is the imaginary part.

IMTAN Function

The Excel IMTAN function calculates the tangent of a complex number provided in x+yi or x+yj format. This engineering function handles trigonometric calculations for complex values that standard TAN cannot process.

OCT2BIN Function

The Excel OCT2BIN function converts octal (base-8) numbers to their binary (base-2) representation. This engineering function is essential for handling number system conversions in technical calculations and digital electronics work.

OCT2DEC Function

The Excel OCT2DEC function converts an octal (base-8) number to its decimal (base-10) equivalent. It supports both positive and negative numbers using two's-complement notation for signed values.

OCT2HEX Function

The OCT2HEX function converts octal (base-8) numbers to hexadecimal (base-16) format, supporting both positive and negative values through two's-complement representation. Perfect for number system conversions in programming, data analysis, and digital electronics calculations.