@searsuite/sear-plugin-formula-engineering

BESSELI returns the modified Bessel function I_n(x). Example: =BESSELI(1.5,1) returns about 0.981666.

BESSELJ returns the Bessel function J_n(x). Example: =BESSELJ(1.9,2) returns about 0.329926.

BESSELK returns the modified Bessel function K_n(x). Example: =BESSELK(1.5,1) returns about 0.277388.

BESSELY returns the Bessel function Y_n(x). Example: =BESSELY(2.5,1) returns about 0.145918.

BIN2DEC converts binary to decimal. Example: =BIN2DEC("1100100") returns 100.

BIN2HEX converts binary to hexadecimal. Example: =BIN2HEX("11111011") returns FB.

BIN2OCT converts binary to octal. Example: =BIN2OCT("1001") returns 11.

BITAND returns the bitwise AND of two 48-bit nonnegative integers. Example: =BITAND(13,25) returns 9.

BITLSHIFT shifts a 48-bit integer left, or right for a negative shift. Example: =BITLSHIFT(4,2) returns 16.

BITOR returns the bitwise OR of two 48-bit nonnegative integers. Example: =BITOR(23,10) returns 31.

BITRSHIFT shifts a 48-bit integer right, or left for a negative shift. Example: =BITRSHIFT(16,2) returns 4.

BITXOR returns the bitwise exclusive OR of two 48-bit nonnegative integers. Example: =BITXOR(5,3) returns 6.

COMPLEX creates Excel complex-number text from real and imaginary coefficients. Example: =COMPLEX(3,4) returns "3+4i".

CONVERT changes a number between compatible measurement units. Example: =CONVERT(1,"mi","km") returns 1.609344.

DEC2BIN converts decimal to binary. Example: =DEC2BIN(9) returns 1001.

DEC2HEX converts decimal to hexadecimal. Example: =DEC2HEX(100) returns 64.

DEC2OCT converts decimal to octal. Example: =DEC2OCT(58) returns 72.

DELTA tests whether two numbers are equal. Example: =DELTA(5,4) returns 0.

ERF returns the error function between lower and optional upper bounds. Example: =ERF(1) returns about 0.842701.

ERF.PRECISE returns the error function from zero to x. Example: =ERF.PRECISE(1) returns about 0.842701.

ERFC returns the complementary error function. Example: =ERFC(1) returns about 0.157299.

ERFC.PRECISE returns the precise complementary error function. Example: =ERFC.PRECISE(1) returns about 0.157299.

GESTEP tests whether a number is at least a threshold. Example: =GESTEP(5,4) returns 1.

HEX2BIN converts hexadecimal to binary. Example: =HEX2BIN("F") returns 1111.

HEX2DEC converts hexadecimal to decimal. Example: =HEX2DEC("A5") returns 165.

HEX2OCT converts hexadecimal to octal. Example: =HEX2OCT("F") returns 17.

IMABS returns the modulus of a complex number. Example: =IMABS("3+4i") returns 5.

IMAGINARY returns the imaginary coefficient. Example: =IMAGINARY("3+4i") returns 4.

IMARGUMENT returns a complex number's angle in radians. Example: =IMARGUMENT("3+4i") returns about 0.9273.

IMCONJUGATE returns the complex conjugate. Example: =IMCONJUGATE("3+4i") returns a 3-4i.

IMCOS returns the cosine of a complex number. Example: =IMCOS("1+i") returns a complex cosine.

IMCOSH returns the hyperbolic cosine of a complex number. Example: =IMCOSH("1+i") returns a complex hyperbolic cosine.

IMCOT returns the cotangent of a complex number. Example: =IMCOT("1+i") returns a complex cotangent.

IMCOTH returns the hyperbolic cotangent. Example: =IMCOTH("1+i") returns a complex value.

IMCSC returns the cosecant of a complex number. Example: =IMCSC("1+i") returns a complex cosecant.

IMCSCH returns the hyperbolic cosecant of a complex number. Example: =IMCSCH("1+i") returns a complex hyperbolic cosecant.

IMDIV divides one complex number by another. Example: =IMDIV("3+4i","5-3i") returns their quotient.

IMEXP returns the exponential of a complex number. Example: =IMEXP("1+i") returns a complex exponential.

IMLN returns the natural logarithm of a complex number. Example: =IMLN("3+4i") returns a complex logarithm.

IMLOG returns a complex logarithm in a chosen base. Example: =IMLOG("8",2) returns 3.

IMLOG10 returns the base-10 logarithm of a complex number. Example: =IMLOG10("3+4i") returns a complex logarithm.

IMLOG2 returns the base-2 logarithm of a complex number. Example: =IMLOG2("3+4i") returns a complex logarithm.

IMPOWER raises a complex number to a real power. Example: =IMPOWER("2+3i",3) returns "-46+9i".

IMPRODUCT multiplies complex numbers and ranges. Example: =IMPRODUCT("3+4i","5-3i") returns "27+11i".

IMREAL returns the real coefficient. Example: =IMREAL("6-9i") returns 6.

IMSEC returns the secant of a complex number. Example: =IMSEC("1+i") returns a complex secant.

IMSECH returns the hyperbolic secant of a complex number. Example: =IMSECH("1+i") returns a complex hyperbolic secant.

IMSIN returns the sine of a complex number. Example: =IMSIN("1+i") returns a complex sine.

IMSINH returns the hyperbolic sine of a complex number. Example: =IMSINH("1+i") returns a complex hyperbolic sine.

IMSQRT returns the square root of a complex number. Example: =IMSQRT("1+i") returns a complex square root.

IMSUB subtracts the second complex number from the first. Example: =IMSUB("13+4i","5+3i") returns "8+i".

IMSUM adds complex numbers and ranges. Example: =IMSUM("3+6i","5-2i") returns "8+4i".

IMTAN returns the tangent of a complex number. Example: =IMTAN("1+i") returns a complex tangent.

IMTANH returns the hyperbolic tangent. Example: =IMTANH("1+i") returns a complex value.

OCT2BIN converts octal to binary. Example: =OCT2BIN("3") returns 11.

OCT2DEC converts octal to decimal. Example: =OCT2DEC("54") returns 44.

OCT2HEX converts octal to hexadecimal. Example: =OCT2HEX("100") returns 40.

Registers engineering formulas into an editor-local registry and returns an idempotent disposer.