Skip to main content

Engineering Functions

  • 6 minutes to read

This document describes engineering functions supported by the non-visual Spreadsheet component.

Name

Description

Syntax

BESSELI

Returns the modified Bessel function In(x).

BESSELI(X, N)

BESSELJ

Calculates the Bessel function Jn(x).

BESSELJ(X, N)

X is the value at which to evaluate the function. N is the order of the Bessel function. If n is not an integer, it is truncated.

BESSELK

Returns the modified Bessel function Kn(x).

BESSELK(X, N)

BESSELY

Returns the Bessel function Yn(x).

BESSELY(X, N)

BIN2DEC

Converts a binary number to decimal.

BIN2DEC(number)

BIN2HEX

Converts a binary number to hexadecimal.

BIN2HEX(number, [places])

Number is the binary number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

BIN2OCT

Converts a binary number to octal.

BIN2OCT(number, [places])

Number is the binary number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

BITAND

Returns a bitwise ‘AND’ of two numbers.

BITAND( number1, number2)

BITLSHIFT

Returns a number shifted left by the specified number of bits.

BITLSHIFT(number, shift_amount)

BITOR

Returns a bitwise ‘OR’ of two numbers.

BITOR(number1, number2)

BITRSHIFT

Returns a number shifted right by the specified number of bits.

BITRSHIFT(number, shift_amount)

BITXOR

Returns a bitwise ‘XOR’ of two numbers.

BITXOR(number1, number2)

COMPLEX

Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.

COMPLEX(real_num,i_num,suffix)

Real_num is the real coefficient of the complex number. I_num is the imaginary coefficient of the complex number. Suffix is the suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be “i”.

CONVERT

Converts a number from one measurement system to another.

CONVERT(number, from_unit, to_unit)

Number is the number to be converted. From_unit is a text string, denoting the current unit. From_unit is a text string, denoting the unit to which the number will be cconverted.

DEC2BIN

Converts a decimal number to binary.

DEC2BIN(number, [places])

Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

DEC2HEX

Converts a decimal number to hexadecimal.

DEC2HEX(number, [places])

Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

DEC2OCT

Converts a decimal number to octal.

DEC2OCT(number, [places])

Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

DELTA

Tests whether two values are equal.

DELTA(number1, number2)

ERF

Returns the error function integrated between lower_limit and upper_limit.

ERF(lower_limit,[upper_limit])

ERFC

Returns the complementary ERF function integrated between x and infinity.

ERFC(x)

ERFC.PRECISE

Returns the complementary ERF function integrated between x and infinity.

ERFC.PRECISE(x)

ERF.PRECISE

Returns the error function.

ERF.PRECISE(x)

GESTEP

Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values.

GESTEP(number,step)

HEX2BIN

Converts a hexadecimal number to binary.

HEX2BIN(number, [places])

Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

HEX2DEC

Converts a hexadecimal number to decimal.

HEX2DEC(number)

HEX2OCT

Converts a hexadecimal number to octal.

HEX2OCT(number, [places])

Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

IMABS

Returns the absolute value (the modulus) of a complex number.

IMABS(inumber)

IMAGINARY

Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.

IMAGINARY(inumber)

IMARGUMENT

Returns the argument theta (an angle expressed in radians) of a complex number.

IMARGUMENT(inumber)

IMCONJUGATE

Returns the complex conjugate of a complex number in x + yi or x + yj text format.

IMCONJUGATE(inumber)

IMCOS

Returns the cosine of a complex number

IMCOS(inumber)

IMCOSH

Returns the hyperbolic cosine of a complex number.

IMCOSH(inumber)

IMCOT

Returns the cotangent of a complex number.

IMCOT(inumber)

IMCSC

Returns the cosecant of a complex number.

IMCSC(inumber)

IMCSCH

Returns the hyperbolic cosecant of a complex number.

IMCSCH(inumber)

IMDIV

Returns the quotient of two complex numbers in x + yi or x + yj text format.

IMDIV(inumber1,inumber2)

IMEXP

Returns the exponential of a complex number in x + yi or x + yj text format.

IMEXP(inumber)

IMLN

Returns the natural logarithm of a complex number in x + yi or x + yj text format.

IMLN(inumber)

IMLOG10

Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.

IMLOG10(inumber)

IMLOG2

Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.

IMLOG2(inumber)

IMPOWER

Returns a complex number raised raised to a power.

IMPOWER(inumber, number)

IMPRODUCT

Returns the product of 1 to 255 complex numbers in x + yi or x + yj text format.

IMPRODUCT(inumber1,inumber2,…)

IMREAL

Returns the real coefficient of a complex number in x + yi or x + yj text format.

IMREAL(inumber)

IMSEC

Returns the secant of a complex number.

IMSEC(inumber)

IMSECH

Returns the hyperbolic secant of a complex number.

IMSECH(inumber)

IMSIN

Returns the sine of a complex number in x + yi or x + yj text format.

IMSIN(inumber)

IMSINH

Returns the hyperbolic sine of a complex number.

IMSINH(inumber)

IMSQRT

Returns the square root of a complex number in x + yi or x + yj text format.

IMSQRT(inumber)

IMSUB

Returns the difference of two complex numbers in x + yi or x + yj text format.

IMSUB(inumber1,inumber2)

IMSUM

Returns the sum of two or more complex numbers.

IMSUM(inumber1, inumber2, …)

IMTAN

Returns the tangent of a complex number.

IMTAN(number)

OCT2BIN

Converts an octal number to binary.

OCT2BIN(number, [places])

Number is the octal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

OCT2DEC

Converts an octal number to decimal.

OCT2DEC(number)

OCT2HEX

Converts an octal number to hexadecimal.

OCT2HEX(number, [places])

Number is the octal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

See Also