Engineering in JQuery Calculate widget

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 non-numeric, 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 non-numeric, 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 non-numeric.

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 non-numeric.

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 non-numeric.

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 non-integer or is greater than (2^48)-1.

  • #VALUE! - occurs if num1 or num2 is a non-numeric 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 non-integer or is greater than (2^48)-1.

  • #VALUE! - occurs if num1 or num2 is a non-numeric 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 non-integer or is greater than (2^48)-1.

  • #VALUE! - occurs if num1 or num2 is a non-numeric 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 non-integer or is greater than (2^48)-1.

  • #VALUE! - occurs if num1 or num2 is a non-numeric 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 non-integer or is greater than (2^48)-1.

  • #VALUE! - occurs if num1 or num2 is a non-numeric 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 non-numeric and when DEC2BIN 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 non-numeric 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 non-numeric.

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 non-numeric.