Excel Spreadsheets Engineering Functions (40)
If you are using a version of Excel earlier than 2007 you need to activate the "Excel Analysis Toolpack" to make the following functions available.
Importance
Functions
What it Does
Rarely Used
BESSELI
Returns the modified Bessel function In(x)
Rarely Used
BESSELJ
Returns the Bessel function Jn(x)
Rarely Used
BESSELK
Returns the modified Bessel function Kn(x)
Rarely Used
BESSELY
Returns the Bessel function Yn(x)
Rarely Used
BIN2DEC
Converts a binary number to decimal
Rarely Used
BIN2HEX
Converts a binary number to hexadecimal
Rarely Used
BIN2OCT
Converts a binary number to octal
Rarely Used
COMPLEX
Converts real and imaginary coefficients into a complex number
Rarely Used
CONVERT
Converts a number from one measurement system to another
Rarely Used
DEC2BIN
Converts a decimal number to binary
Rarely Used
DEC2HEX
Converts a decimal number to hexadecimal
Rarely Used
DEC2OCT
Converts a decimal number to octal
Rarely Used
DELTA
Tests whether two values are equal
Rarely Used
ERF
Returns the error function
Rarely Used
ERFC
Returns the complementary error function
Rarely Used
GESTEP
Tests whether a number is greater than a threshold value
Rarely Used
HEX2BIN
Converts a hexadecimal number to binary
Rarely Used
HEX2DEC
Converts a hexadecimal number to decimal
Rarely Used
HEX2OCT
Converts a hexadecimal number to octal
Rarely Used
IMABS
Returns the absolute value (modulus) of a complex number
Rarely Used
IMAGINARY
Returns the imaginary coefficient of a complex number
Rarely Used
IMARGUMENT
Returns the argument theta, an angle expressed in radians
Rarely Used
IMCONJUGAT
Returns the complex conjugate of a complex number
Rarely Used
IMCOS
Returns the cosine of a complex number
Rarely Used
IMDIV
Returns the quotient of two complex numbers
Rarely Used
IMEXP
Returns the exponential of a complex number
Rarely Used
IMLN
Returns the natural logarithm of a complex number
Rarely Used
IMLOG10
Returns the base-10 logarithm of a complex number
Rarely Used
IMLOG2
Returns the base-2 logarithm of a complex number
Rarely Used
IMPOWER
Returns a complex number raised to an integer power
Rarely Used
IMPRODUCT
Returns the product of two complex numbers
Rarely Used
IMREAL
Returns the real coefficient of a complex number
Rarely Used
IMSIN
Returns the sine of a complex number
Rarely Used
IMSQRT
Returns the square root of a complex number
Rarely Used
IMSUB
Returns the difference between two complex numbers
Rarely Used
IMSUM
Returns the sum of complex numbers
Rarely Used
OCT2BIN
Converts an octal number to binary
Rarely Used
OCT2DEC
Converts an octal number to decimal
Rarely Used
OCT2HEX
Converts an octal number to hexadecimal