# 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.