Engineering Functions

The functions that relate to engineering calculations are:

 

BESSELI(value,order)

This function calculates the modified Bessel function of the first kind evaluated for purely imaginary arguments.

argument

description

value

Value at which to evaluate the function

order

Number representing the order of the function; if it is not an integer, it is truncated

example: BESSELI(1.8,2) gives the result 0.5260402117

 

 

BESSELJ(value,order)

This function calculates the Bessel function of the first kind.

argument

description

value

Value at which to evaluate the function

order

Number representing the order of the function; if it is not an integer, it is truncated

example: BESSELJ(1.85,2) gives the result 0.31812827879

 

 

BESSELK(value,order)

This function calculates the modified Bessel function of the second kind evaluated for purely imaginary arguments.

argument

Description

value

Value at which to evaluate the function

order

Number representing the order of the function; if it is not an integer, it is truncated

example: BESSELK(1.85,2) gives the result 0.32165379

 

 

BESSELY(value,order)

This function calculates the Bessel function of the second kind.

argument

Description

value

Value at which to evaluate the function

order

Number representing the order of the function; if it is not an integer, it is truncated

example: BESSELY(2.85,1) gives the result 0.2801918953

 

 

BIN2DEC(number)

This function converts a binary number to a decimal number.

 

BIN2HEX(number,places)

This function converts a binary number to a hexadecimal number.

argument

description

number

Binary numeric value to convert

places

[Optional] Number of characters to return; if not an integer, the number is truncated

 

BIN2OCT(number,places)

This function converts a binary number to an octal number.

argument

description

number

Binary numeric value to convert

places

[Optional] Number of characters to return; if not an integer, the number is truncated

 

COMPLEX(realcoeff,imagcoeff,suffix)

This function converts real and imaginary coefficients into a complex number.

argument

description

realcoeff

Coefficient of the real part of the complex number

imagcoeff

Coefficient of the imaginary part of the complex number

suffix

(Optional) Suffix of the imaginary part of the complex number, may be either "i "or "j". If omitted, "i" is used.

 

CONVERT(number,from-unit,to-unit)

This function converts a number from one measurement system to its equivalent in another measurement system.

argument

description

number

Numeric value to convert

from-unit

Convertible units of numeric value to convert

to-unit

Convertible units of desired result

 

DEC2BIN(number,places)

This function converts a decimal number to a binary number.

argument

description

number

Decimal numeric value to convert in the range of -512 to 511

places

[Optional] Number of characters to return; if not an integer, the number is truncated

 

DEC2HEX(number,places)

This function converts a decimal number to a hexadecimal number.

argument

description

number

Decimal numeric value to convert in the range of -549,755,813,888 to 549,755,813,887

places

[Optional] Number of characters to return; if not an integer, the number is truncated

 

DEC2OCT(number,places)

This function converts a decimal number to an octal number.

argument

description

number

Decimal numeric value to convert in the range of -536,870,912 and 536,870,911

places

[Optional] Number of characters to return; if not an integer, the number is truncated

 

DELTA(value1,value2)

This function identifies whether two values are equal. Returns 1 if they are equal; returns 0 otherwise.

example: DELTA(3,2) gives the result 0

 

ERF(limit,upperlimit)

This function calculates the error function integrated between a lower and an upper limit.

argument

description

limit

Either this is the lower limit, if the upper limit is supplied, or it is the upper limit (with 0 as the lower limit) if the second argument is not supplied

upperlimit

[Optional] Upper limit for integrating the function

If there upperlimit is not supplied, the function calculates:

ERF Equation (hi-lo limits)

where x is the limit argument.

If there upperlimit is supplied, the function calculates:

func-erf-hilo

where lo is the limit argument and hi is the upperlimit argument.

example: ERF(0.25,0.85) gives the result 0.494341544

 

ERFC(lowerlimit)

This function calculates the complementary error function integrated between a lower limit and infinity.

This function calculates the complementary error function as follows:

Equation ERFC

where x is the lower limit specified in the argument.

example: ERFC(0.49) gives the result 0.48833174

 

GESTEP(number,step)

This function, greater than or equal to step, returns an indication of whether a number is equal to a threshold.

argument

description

number

Value to test against the step (which is either step or zero)

step

[Optional] Value of the threshold against which to test; if omitted, uses zero

example: GESTEP(43) gives the result 1

 

 

HEX2BIN(number, places)

This function converts a hexadecimal number to a binary number.

argument

description

number

Hexadecimal numeric value to convert, must be between FFFFFFFE00 and 1FF

places

[Optional] Number of characters to return; if not an integer, the number is truncated

 

HEX2DEC(number)

This function converts a hexadecimal number to a decimal number.

 

HEX2OCT(number, places)

This function converts a hexadecimal number to an octal number.

argument

Description

number

Hexadecimal numeric value to convert, must be between FFE0000000 and 1FFFFFFF

places

[Optional] Number of characters to return; if not an integer, the number is truncated

 

IMABS(complexnum)

This function returns the absolute value or modulus of a complex number.

example: IMABS("3+5i") 5,8309518948453

 

IMAGINARY(complexnum)

This function returns the imaginary coefficient of a complex number.

example: IMAGINARY("3+5j") gives the result 5

 

IMARGUMENT(complexnum)

This function returns the argument theta, which is an angle expressed in radians.

example: IMARGUMENT("3+5j") gives the result 1,03037682652431

 

IMCONJUGATE(complexnum)

This function returns the complex conjugate of a complex number.

example: IMCONJUGATE("3+5j") gives the result 3-5j

 

IMCOS(complexnum)

This function returns the cosine of a complex number.

 

IMDIV(complexnum,complexdenom)

This function returns the quotient of two complex numbers.

example: IMDIV("3+5i","10+20i") gives the result 0.26-0.02i

 

IMEXP(complexnum)

This function returns the exponential of a complex number.

 

IMLN(complexnum)

This function returns the natural logarithm of a complex number.

 

IMLOG10(complexnum)

This function returns the common logarithm of a complex number.

 

IMLOG2(complexnum)

This function returns the base-2 logarithm of a complex number.

 

IMPOWER(complexnum,powernum)

This function returns a complex number raised to a power.

 

IMPRODUCT(complexnum1,complexnum2, ...)

This function returns the product of up to 29 complex numbers in the ""x+yi"" or ""x+yj"" text format.

 

IMSIN(complexnum)

This function returns the sine of a complex number in the x+yi or x+yj text format.

 

IMREAL(complexnum)

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

 

IMSQRT(complexnum)

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

 

IMSUB(complexnum1,complexnum2)

This function returns the difference of two complex numbers in the x+yi or x+yj text format.

 

IMSUM(complexnum1,complexnum2, ...)

This function returns the sum of two or more complex numbers in the x+yi or x+yj text format.

 

OCT2BIN(number,places)

This function converts an octal number to a binary number.

argument

description

number

Octal numeric value to convert, must be 10 characters or less, and must be between 7777777000 and 777

places

[Optional] Number of characters to return; if not an integer, the number is truncated

 

OCT2DEC(number)

This function converts an octal number to a decimal number.

 

OCT2HEX(number,places)

This function converts an octal number to a hexadecimal number.

argument

description

number

Octal numeric value to convert, must be 10 characters or less

places

[Optional] Number of characters to return; if not an integer, the number is truncated

 

 

 

See Also:


Formula Functions

Data: Convertible Units