Engineering
18 Dec 20176 minutes to read
BESSELI
The BESSELI
function returns the modified Bessel function In(X)
, which is equivalent to the Bessel function evaluated for purely imaginary arguments.
Syntax:
BESSELI(X, N)
where:

X is the value at which the function is to be evaluated.

N is the positive integer, representing the order of the function. If the N value is represented as decimal, it is truncated as integer.
Remarks:

Returns
#NUM!
, if the supplied value of n is lesser than 0. 
If any of the supplied arguments are nonnumeric, it returns
#VALUE!
error.
BESSELJ
The BESSELJ
function returns the Bessel function Jn(X)
.
Syntax:
BESSELJ( X, N )
where:

X is the value at which the function is to be evaluated.

N is the order of the Bessel function and it must be a positive number.
Remarks:

Returns
#NUM!
if the supplied value of n is lesser than 0. 
If any of the supplied arguments are nonnumeric, it returns
#VALUE!
error.
BESSELK
The BESSELK
function returns the modified Bessel function Kn(X)
, which is equivalent to the Bessel function evaluated for purely imaginary arguments.
Syntax:
BESSELK( X, N )
where:

X is the value at which the function is to be evaluated.

N is the positive integer which denotes the order of the modified Bessel function.
Remarks:

Returns
#NUM!
, if either N is Lesser than 0 or X is lesser than or equal to 0. 
Returns
#VALUE!
, if any of the supplied argument are nonnumeric.
BESSELY
The BESSELY
function returns the Bessel function Yn(X)
.
Syntax:
BESSELY( X, N )
where:

X is the value at which the function is to be evaluated.

N is the positive integer which denotes the order of the Bessel function.
Remarks:

Returns
#NUM!
, if either N is Lesser than 0 or X is lesser than or equal to 0. 
Returns
#VALUE!
, if any of the supplied argument are nonnumeric.
BIN2OCT
The BIN2OCT
function converts a binary number into an octal number.
Syntax:
BIN2OCT(num, places)
where:

num is the decimal integer you want to convert.

places is the number of characters to use.
BIN2HEX
The BIN2HEX
function converts a binary number into a hexadecimal.
Syntax:
BIN2HEX(num places)
where:

num is the decimal integer you want to convert.

places is the number of characters to use.
Remarks:

#NUM!
occurs when number is not a valid binary number, when places is negative. 
#VALUE!
occurs when places is nonnumeric.
BIN2DEC
The BIN2DEC
function converts a binary number into a decimal number.
Syntax:
BIN2DEC(num)
where:
 num is the binary number that you want to convert.
Remarks:

#NUM!
occurs when number is not a valid binary number or when number contains more than 10 characters.
BITAND
The BITAND
function returns the bitwise AND
of two numbers.
Syntax:
BITAND(num1,num2)
Where:
 num1 and num2 should be in decimal format.
Remarks:

#NUM!
 occurs if num1 or num2 is less than zero, if num1 or num2 is a noninteger or is greater than (2^48)1. 
#VALUE!
 occurs if num1 or num2 is a nonnumeric value.
BITLSHIFT
The BITLSHIFT
function returns a number shifted left by specified number of bits.
Syntax:
BITLSHIFT(num1,num2)
Where:

num1 must be an integer greater than or equal to 0.

Num2 must be an integer.
Remarks:

#NUM!
 occurs if num1 or num2 is less than zero, if num1 or num2 is a noninteger or is greater than (2^48)1. 
#VALUE!
 occurs if num1 or num2 is a nonnumeric value.
BITOR
The BITOR
function returns a bitwise ‘OR’ of two numbers.
Syntax:
BITOR(num1, num2)
Where:
 num1 and num2 should be in decimal format.
Remarks:

#NUM!
 occurs if num1 or num2 is less than zero, if num1 or num2 is a noninteger or is greater than (2^48)1. 
#VALUE!
 occurs if num1 or num2 is a nonnumeric value.
BITRSHIFT
The BITRSHIFT
function returns a number shifted right by the specified number of bits.
Syntax:
BITRSHIFT(num1,num2)
Where:

num1 must be an integer greater than or equal to 0.

Num2 must be an integer.
Remarks:

#NUM!
 occurs if num1 or num2 is less than zero, if num1 or num2 is a noninteger or is greater than (2^48)1. 
#VALUE!
 occurs if num1 or num2 is a nonnumeric value.
BITXOR
The BITXOR
function returns bitwise XOR
of two numbers.
Syntax:
BITXOR(num1, num2)
Where:
 num1 and num2 should be in decimal format.
Remarks:

#NUM!
 occurs if num1 or num2 is less than zero, if num1 or num2 is a noninteger or is greater than (2^48)1. 
#VALUE!
 occurs if num1 or num2 is a nonnumeric value.
DEC2BIN
The DEC2BIN
function converts a decimal number into a binary number.
Syntax:
DEC2BIN(num,places)
where:

num is the decimal integer you want to convert.

places is the number of characters to use.
Remarks:

#NUM!
occurs when number < 512 or if number >511 and when places is zero or negative. 
#VALUE!
occurs when number or places is nonnumeric and whenDEC2BIN
requires more than the number of characters specified in places.
DEC2OCT
The DEC2OCT
function converts a decimal number into an octal number.
Syntax:
DEC2OCT(num, places)
where:

num is the decimal integer you want to convert.

places is the number of characters to use.
Remarks:

#NUM!
occurs when number < 512 or if number >511 and when places is zero or negative. 
#VALUE!
occurs when the number or places is nonnumeric and when DEC2OCT requires more than the number of characters specified in places.
HEX2BIN
The HEX2BIN
function converts a hexadecimal number into a binary number.
Syntax:
HEX2BIN(num, places)
where:

num is the decimal integer you want to convert.

places is the number of characters to use.
Remarks:

#NUM!
occurs when number is not a valid binary number and when places is negative. 
#VALUE!
occurs when places is nonnumeric.
HEX2OCT
The HEX2OCT
function converts a hexadecimal number into an octal number.
Syntax:
HEX2OCT(num, places)
where:

num is the hexadecimal integer you want to convert.

places is the number of characters to use.
Remarks:

#NUM!
occurs when number is not a valid hexadecimal number and when places is negative. 
#VALUE!
occurs when places is nonnumeric.