Advanced Excel - Engineering Functions


Advertisements


The Excel Engineering functions perform the most commonly used Engineering calculations, many of which relate to Bessel functions, complex numbers, or converting between different bases.

Engineering Functions

The following table lists all the Engineering functions −

S.No. Function and Description
1 BESSELI

Returns the modified Bessel function In(x)

2 BESSELJ

Returns the Bessel function Jn(x)

3 BESSELK

Returns the modified Bessel function Kn(x)

4 BESSELY

Returns the Bessel function Yn(x)

5 BIN2DEC

Converts a binary number to decimal

6 BIN2HEX

Converts a binary number to hexadecimal

7 BIN2OCT

Converts a binary number to octal

8 BITAND

Returns a 'Bitwise And' of two numbers

9 BITLSHIFT

Returns a value number shifted left by shift_amount bits

10 BITOR

Returns a bitwise OR of 2 numbers

11 BITRSHIFT

Returns a value number shifted right by shift_amount bits

12 BITXOR

Returns a bitwise 'Exclusive Or' of two numbers

13 COMPLEX

Converts real and imaginary coefficients into a complex number

14 CONVERT

Converts a number from one measurement system to another

15 DEC2BIN

Converts a decimal number to binary

16 DEC2HEX

Converts a decimal number to hexadecimal

17 DEC2OCT

Converts a decimal number to octal

18 DELTA

Tests whether two values are equal

19 ERF

Returns the error function

20 ERF.PRECISE

Returns the error function

21 ERFC

Returns the complementary error function

22 ERFC.PRECISE

Returns the complementary error function

23 GESTEP

Tests whether a number is greater than a threshold value

24 HEX2BIN

Converts a hexadecimal number to binary

25 HEX2DEC

Converts a hexadecimal number to decimal

26 HEX2OCT

Converts a hexadecimal number to octal

27 IMABS

Returns the absolute value (modulus) of a complex number

28 IMAGINARY

Returns the imaginary coefficient of a complex number

29 IMARGUMENT

Returns the argument theta, an angle expressed in radians

30 IMCONJUGATE

Returns the complex conjugate of a complex number

31 IMCOS

Returns the cosine of a complex number

32 IMCOSH

Returns the hyperbolic cosine of a complex number

33 IMCOT

Returns the cotangent of a complex number

34 IMCSC

Returns the cosecant of a complex number

35 IMCSCH

Returns the hyperbolic cosecant of a complex number

36 IMDIV

Returns the quotient of two complex numbers

37 IMEXP

Returns the exponential of a complex number

38 IMLN

Returns the natural logarithm of a complex number

39 IMLOG2

Returns the base-2 logarithm of a complex number

40 IMLOG10

Returns the base-10 logarithm of a complex number

41 IMPOWER

Returns a complex number raised to an integer power

42 IMPRODUCT

Returns the product of complex numbers

43 IMREAL

Returns the real coefficient of a complex number

44 IMSEC

Returns the secant of a complex number

45 IMSECH

Returns the hyperbolic secant of a complex number

46 IMSIN

Returns the sine of a complex number

47 IMSINH

Returns the hyperbolic sine of a complex number

48 IMSQRT

Returns the square root of a complex number

49 IMSUB

Returns the difference of two complex numbers

50 IMSUM

Returns the sum of complex numbers

51 IMTAN

Returns the tangent of a complex number

52 OCT2BIN

Converts an octal number to binary

53 OCT2DEC

Converts an octal number to decimal

54 OCT2HEX

Converts an octal number to hexadecimal



Advertisements
E-Books Store