Microsoft Office Tutorials and References
In Depth Information
* Indicates a function introduced in Excel 2010.** Indicates a function introduced in Excel 2013.
Table A-5: Engineering Category Functions
Function
What It Does
BESSELI
Returns the modified Bessel function In(x).
BESSELJ
Returns the Bessel function Jn(x).
BESSELK
Returns the modified Bessel function Kn(x).
BESSELY
Returns the Bessel function Yn(x).
BIN2DEC
Converts a binary number to decimal.
BIN2HEX
Converts a binary number to hexadecimal.
BIN2OCT
Converts a binary number to octal.
BITAND**
Returns a bitwise AND of two numbers.
BITLSHIFT**
Returns a value number shifted left by shift_amount bits.
BITOR**
Returns a bitwise OR of two numbers.
BITRSHIFT**
Returns a value number shifted right by shift_amount bits.
BITXOR**
Returns a bitwise Exclusive OR of two numbers.
COMPLEX
Converts real and imaginary coefficients into a complex number.
CONVERT
Converts a number from one measurement system to another.
DEC2BIN
Converts a decimal number to binary.
DEC2HEX
Converts a decimal number to hexadecimal.
DEC2OCT
Converts a decimal number to octal.
DELTA
Tests whether two values are equal.
ERF
Returns the error function.
ERF.PRECISE*
Returns the error function.
ERFC
Returns the complementary error function.
ERFC.PRECISE* Returns the complementary error function.
Search JabSto ::




Custom Search