BESSELI Function in Excel: Modified Bessel Function In(x)
BESSELI returns the modified Bessel function In(x), used in heat transfer, signal processing and vibration problems.
Read article →Engineering
Excel Engineering functions explained with syntax, examples and common mistakes.
BESSELK Function in Excel: Modified Bessel Function Kn(x)
BESSELK Function in Excel: Modified Bessel Function Kn(x)
EngineeringLevel: ExpertAvailable in: Excel 2007+BESSELK returns the modified Bessel function of the second kind, Kn(x).Syntax=BESSELK(x, n)ArgumentWhat.
Read article →OCT2DEC Function in Excel: Octal to Decimal
OCT2DEC Function in Excel: Octal to Decimal
OCT2DEC converts a octal number to decimal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →BIN2OCT Function in Excel: Binary to Octal
BIN2OCT Function in Excel: Binary to Octal
BIN2OCT converts a binary number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →HEX2BIN Function in Excel: Hexadecimal to Binary
HEX2BIN Function in Excel: Hexadecimal to Binary
EngineeringLevel: IntermediateAvailable in: Excel 2007+HEX2BIN converts hex to binary text — each hex digit becomes four bits.Syntax=HEX2BIN(number.
Read article →BITRSHIFT Function in Excel: Shift Bits to the Right
BITRSHIFT Function in Excel: Shift Bits to the Right
BITRSHIFT shifts a number's bits right, the same as integer division by a power of 2. Used to read packed flags and bit fields.
Read article →BITLSHIFT Function in Excel: Shift Bits Left
BITLSHIFT Function in Excel: Shift Bits Left
EngineeringLevel: ExpertAvailable in: Excel 2013+BITLSHIFT shifts bits left, multiplying by powers of two.Syntax=BITLSHIFT(number.
Read article →BITXOR Function in Excel: Bitwise Exclusive OR
BITXOR Function in Excel: Bitwise Exclusive OR
EngineeringLevel: ExpertAvailable in: Excel 2013+BITXOR flips bits — on where exactly one input has them on.Syntax=BITXOR(number1, number2)ArgumentWhat it.
Read article →BITOR Function in Excel: Bitwise OR
BITOR Function in Excel: Bitwise OR
EngineeringLevel: ExpertAvailable in: Excel 2013+BITOR combines flag numbers: a bit is on if it is on in either input.Syntax=BITOR(number1.
Read article →BITAND Function in Excel: Bitwise AND
BITAND Function in Excel: Bitwise AND
BITAND compares numbers bit by bit. Useful for decoding status flags stored as one number.
Read article →DEC2OCT Function in Excel: Decimal to Octal
DEC2OCT Function in Excel: Decimal to Octal
DEC2OCT converts a decimal number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →OCT2HEX Function in Excel: Octal to Hexadecimal
OCT2HEX Function in Excel: Octal to Hexadecimal
OCT2HEX converts a octal number to hexadecimal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →