Engineering Functions

Function Index

besselJ besselY bin2dec bin2hex bin2oct complex dec2bin dec2hex dec2oct delta erf ERF.PRECISE erfc ERFC.PRECISE getStep hex2bin hex2dec hex2oct imAbs imaginary imArgument imConjugate imCos imDiv imExp imLn imLog10 imLog2 imPower imProduct imReal imSin imSqrt imSub imSum oct2bin oct2dec oct2hex

Engineering Functions


besselJ(x, n)

Returns the Bessel function of the n-th order for a given value x.

=besselJ(1.9, 2) → 0.32992572769239

besselY(x, n)

Returns the Bessel/Weber function of the n-th order for a given value x.

=besselY(2.5, 1) → 0.14591813796679

bin2dec(n)

Converts n representing a binary number to a decimal number. The argument may contain up to 10 characters. The most significant bit determines the sign. Negative numbers use two’s complement.

=bin2dec("1100100") → 100
=bin2dec("1111111111") → -1

bin2hex(n, [l])

Converts a binary number n to a hexadecimal string of length l. may contain up to 10 characters. The most significant bit determines the sign. Negative numbers use two’s complement. If l is omitted, it defaults to 10.

=bin2hex(11111011, 4) → "00FB"
=bin2hex("1111111111") → "FFFFFFFFFF"

bin2oct(n, [l])

Converts a binary number n to an octal string of length l. may contain up to 10 characters. The most significant bit determines the sign. Negative numbers use two’s complement. If l is omitted, it defaults to 10.

=bin2oct(1001, 3) → "011"
=bin2oct(1111111111) → "7777777777"

complex(x, y, [i])

Converts real and imaginary coefficients into a complex number string. The optional i argument specifies the imaginary suffix (default: "i").

=complex(1, 2) → "1 + 2i"
=complex(3.5, 4.6, "j") → "3.5 + 4.6j"

dec2bin(n, [l])

Converts a decimal number n (range: -512 to 511) to a binary string of length l. Negative numbers use two’s complement. If l is omitted, it defaults to 10.

=dec2bin(9, 4) → "1001"
=dec2bin(-1) → "1111111111"

dec2hex(n, [l])

Converts a decimal number n to a hexadecimal string of length l. Negative numbers use two’s complement. If l is omitted, it defaults to 10.

=dec2hex(100, 4) → "064"
=dec2hex(-1) → "FFFFFFFFFF"

dec2oct(n, [l])

Converts a decimal number n (range: -536870912 to 536870911) to an octal string of length l. Negative numbers use two’s complement. If l is omitted, it defaults to 10.

=dec2oct(58, 3) → "1001"
=dec2oct(-1) → "7777777777"

delta(x, [y])

Returns 1 if x = y, otherwise 0. If y is omitted, it defaults to 0.

=delta(12, 11) → 0
=delta(0) → 1

erf(x1, [x2])

Returns the value of the error function integrated between the specified limits. If x2 is omitted, integration is performed between 0 and x1.

=erf(0.745) → 0.70792891807065

ERF.PRECISE(x1, x2)

Returns the error function evaluated over the interval from x1 to x2.

The returned value is:
ERF(x2) − ERF(x1)

Both x1 and x2 must be numeric. If x2 is omitted, the function returns ERF(x1).

Examples:
ERF.PRECISE(0, 1) returns ERF(1) − ERF(0).
ERF.PRECISE(1, 2) returns ERF(2) − ERF(1).
ERF.PRECISE(1) returns ERF(1).

erfc(x)

Returns the complementary error function integrated between x and infinity.

=erfc(1) → 0.15722921001143

ERFC.PRECISE(x1, x2)

Returns the complementary error function evaluated over the interval from x1 to x2.

The returned value is:
ERFC(x1) − ERFC(x2)

Both x1 and x2 must be numeric. If x2 is omitted, the function returns ERFC(x1).

Examples:
ERFC.PRECISE(0, 1) returns ERFC(0) − ERFC(1).
ERFC.PRECISE(1, 2) returns ERFC(1) − ERFC(2).
ERFC.PRECISE(1) returns ERFC(1).

getStep(x, [y])

Returns 1 if x > y, otherwise 0. Default value of y is 0.

=getStep(1.4) → 1

hex2bin(n, [l])

Converts a hexadecimal number n to a binary string of length l. may contain up to 10 characters. Negative numbers use two’s complement. If l is omitted, it defaults to 10.

=hex2bin("F", 8) → "00001111"
=hex2bin("FFFFFFFFFF") → "1111111111"

hex2dec(n)

Converts a hexadecimal number n to a decimal number. may contain up to 10 characters. Negative numbers use two’s complement.

=hex2dec("A5") → 165
=hex2dec("FFFFFFFFFF") → -1

hex2oct(n, [l])

Converts a hexadecimal number n to an octal string of length l. may contain up to 10 characters. Negative numbers use two’s complement. If l is omitted, it defaults to 10.

=hex2oct("F", 3) → "017"
=hex2oct("FFFFFFFFFF") → "7777777777"

imAbs(z)

Returns the absolute value of a complex number z.

=imAbs("5 + 12i") → 13

imaginary(z)

Returns the imaginary coefficient of a complex number z.

=imaginary("5 + 12i") → 12

imArgument(z)

Returns the argument (angle) t such that:
z = |z|(cos(t) + sin(t)i).

=imArgument("3 + 4i") → 0.92727521800161

imConjugate(z)

Returns the complex conjugate of z.

=imConjugate("3 + 4i") → "3 - 4i"

imCos(z)

Returns the cosine of a complex number z.

=imCos("1 + 1i") → "0.83373002513115 + 0.98889770576287i"

imDiv(z1, z2)

Divides z1 by z2 and returns the result.

=imDiv("1 + 2i", "2 + 1i") → "0.8 + 0.6i"

imExp(z)

Returns e^z for a complex number z.

=imExp("1 + 1i") → "1.43869393991589 + 2.28735528717884i"

imLn(z)

Returns the natural logarithm of a complex number z.

=imLn("3 + 4i") → "1.6094379124341 + 0.92729521800161i"

imLog10(z)

Returns the base‑10 logarithm of a complex number z.

=imLog10("3+4i") → "0.69897000433601 + 0.40271919627337i"

imLog2(z)

Returns the base‑2 logarithm of a complex number z.

=imLog2("3 + 4i") → "2.23192809488732 + 1.33780421245095i"

imPower(z, n)

Raises 'z' to the power of 'n' and returns the result. The 'z' argument represents a complex number in the form: "x + yi", x, or "yi".

=imPower("2+3i", 3) returns "-46 + 9i"

imProduct(z1, z2, ...)

Multiplies all the specified arguments which can be complex numbers or arrays of complex numbers in the form: "x + yi", x, or "yi". Empty cells in arrays are skipped.

=imProduct("3+4i", "5-3i") returns "27 + 11i"

imReal(z)

Returns the real coefficient of 'z'. The 'z' argument represents a complex number in the form: "x + yi", x, or "yi".

=imReal("3 + 4i") returns 3

imSin(z)

Returns the sine of 'z'. The 'z' argument represents a complex number in the form: "x + yi", x, or "yi".

=imSin("3 + 4i") returns "3.85373803791938 - 27.0168132580039i"

imSqrt(z)

Returns the squre root of 'z'. The 'z' argument represents a complex number in the form: "x + yi", x, or "yi".

=imSqrt("1 + i") returns "1.09868411346781 + 0.45508986056223i"

imSub(z1, z2)

Returns the difference between of 'z1' and 'z2'. The 'z1' and 'z2' arguments represent complex numbers in the form: "x + yi", x, or "yi".

=imSub("10 + 5i", "9 + 4i") returns "1 + 1i"

imSum(v1, v2, ...)

Adds all the specified arguments which can be complex numbers or arrays of complex numbers in the form: "x + yi", x, or "yi".

=imSum("1 + 1i", "2 + 2i", {"1 + 1i", "1 + 1i"}, 1, "1i") returns "6 + 6i"

oct2bin(n, [l])

Converts 'n' representing an octal number to a string representing a binary number consisting of 'l' characters. The 'n' argument can contain up to 10 characters and it must be in the range [-512, 511]. The most significant bit in 'n' determines its sign. Negative numbers are represented in two's complement format. The 'l' argument must be in the range [0, 10]. If it's omitted, it's assumed to be 10.

=oct2bin(3, 3) returns "011"
=oct2bin(7777777000) returns "1000000000"

oct2dec(n)

Converts 'n' representing an octal number to a decimal number. The 'n' argument can contain up to 10 characters. The most significant bit in 'n' determines its sign. Negative numbers are represented in two's complement format.

=oct2dec(54) returns 44
=oct2dec(7777777777) returns -1

oct2hex(n, [l])

Converts 'n' representing an octal number to a string representing a hexadecimal number consisting of 'l' characters. The 'n' argument can contain up to 10 characters. The most significant bit in 'n' determines its sign. Negative numbers are represented in two's complement format. The 'l' argument must be in the range [0, 10]. If it's omitted, it's assumed to be 10.

=oct2hex(100, 4) returns "0040"
=oct2hex(7777777777) returns "FFFFFFFFFF"