Microsoft Excel includes a variety of engineering functions that are designed to perform specific calculations commonly used in engineering and scientific fields. Here are some notable engineering functions in Excel:
1. BESSELI:
– Syntax: BESSELI(x, n)
– Returns the modified Bessel function In(x) for a given value of x and order n.
2. BESSELJ:
– Syntax: BESSELJ(x, n)
– Returns the Bessel function Jn(x) for a given value of x and order n.
3. BESSELK:
– Syntax: BESSELK(x, n)
– Returns the modified Bessel function Kn(x) for a given value of x and order n.
4. BESSELY:
– Syntax: BESSELY(x, n)
– Returns the Bessel function Yn(x) for a given value of x and order n.
5. BIN2DEC:
– Syntax: BIN2DEC(binary_number)
– Converts a binary number to its decimal equivalent.
6. DEC2BIN:
– Syntax: DEC2BIN(decimal_number, [number_of_digits])
– Converts a decimal number to its binary equivalent.
7. BITAND:
– Syntax: BITAND(number1, number2)
– Performs a bitwise AND operation on two numbers.
8. BITOR:
– Syntax: BITOR(number1, number2)
– Performs a bitwise OR operation on two numbers.
9. BITXOR:
– Syntax: BITXOR(number1, number2)
– Performs a bitwise XOR operation on two numbers.
10. DELTA:
– Syntax: DELTA(number1, [number2])
– Tests if two values are equal. Returns 1 if they are equal; otherwise, returns 0.
11. IMABS:
– Syntax: IMABS(inumber)
– Returns the absolute value (magnitude) of a complex number.
12. IMAGINARY:
– Syntax: IMAGINARY(inumber)
– Returns the imaginary coefficient of a complex number.
13. IMARGUMENT:
– Syntax: IMARGUMENT(inumber)
– Returns the argument theta, an angle expressed in radians.
14. IMCONJUGATE:
– Syntax: IMCONJUGATE(inumber)
– Returns the complex conjugate of a complex number.
15. IMCOS:
– Syntax: IMCOS(inumber)
– Returns the cosine of a complex number.
These are just a few examples of the engineering functions available in Excel. Depending on your specific needs, you may find other functions in Excel’s function library that are relevant to your engineering calculations. If you have a specific calculation in mind, feel free to provide more details, and I can offer more targeted assistance.
<< Go Back to Excel Function Categories | Excel Functions | Learn Excel