Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Functions > Engineering

 
BESSELI*The Bessel function evaluated for purely imaginary arguments.
BESSELJ*The modified Bessel function represented by J(x).
BESSELK*The modified Bessel function represented by K(x).
BESSELY*The modified Bessel function represented by Y(x).
BIN2DEC*The number converted from binary to decimal.
BIN2HEX*The number converted from binary to hexadecimal.
BIN2OCT*The number converted from binary to octal.
BITAND(2013) The bitwise and of two numbers.
BITLSHIFT(2013) The number shifted left by a number of bits.
BITOR(2013) The bitwise or of two numbers.
BITRSHIFT(2013) The number shifted right by a number of bits.
BITXOR(2013) The bitwise exclusive or of two numbers.
COMPLEX*The complex number given real and imaginary coefficients.
CONVERT*The number in one measurement system converted to another.
DEC2BIN*The number converted from decimal to binary.
DEC2HEX*The number converted from decimal to hexadecimal.
DEC2OCT*The number converted from decimal to octal.
DELTA*The numerical value indicating if two numbers are equal.
ERF*The error function integrated between two limits.
ERF.PRECISE(2010) The error function.
ERFC*The complementary ERF function integrated between x and infinity.
ERFC.PRECISE(2010) The complementary ERF function integrated between x and infinity.
GESTEP*The boolean value depending if the number is greater than a threshold value.
HEX2BIN*The number converted from hexadecimal to binary.
HEX2DEC*The number converted from hexadecimal to decimal.
HEX2OCT*The number converted from hexadecimal to octal.
IMABS*The absolute value (modulus) of a complex number.
IMAGINARY*The imaginary coefficient of a complex number.
IMARGUMENT*The theta argument (an angle in radians).
IMCONJUGATE*The complex conjugate of a complex number.
IMCOS*The cosine of a complex number.
IMCOSH(2013) The hyperbolic cosine of a complex number.
IMCOT(2013) The cotangent of a complex number.
IMCSC(2013) The cosecant of a complex number.
IMCSCH(2013) The hyperbolic cosecant of a complex number.
IMDIV*The quotient of two complex numbers.
IMEXP*The exponential of a complex number.
IMLN*The natural logarithm of a complex number.
IMLOG10*The base-10 logarithm of a complex number.
IMLOG2*The base-2 logarithm of a complex number.
IMPOWER*The complex number raised to an integer number.
IMPRODUCT*The product of two or more complex numbers.
IMREAL*The real coefficient of a complex number.
IMSEC(2013) The secant of a complex number.
IMSECH(2013) The hyperbolic secant of a complex number.
IMSIN*The sine of a complex number.
IMSINH(2013) The hyperbolic sine of a complex number.
IMSQRT*The square root of a complex number.
IMSUB*The difference of two complex numbers.
IMSUM*The sum of two or more complex numbers.
IMTAN(2013) The tangent of a complex number.
OCT2BIN*The number converted from octal to binary.
OCT2DEC*The number converted from octal to decimal.
OCT2HEX*The number converted from octal to hexadecimal.
 
 Note: * These are Analysis ToolPak functions in Excel 2003

 © Better Solutions Limited 04-Jun-2013Top