﻿ Engineering Functions

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:

where x is the limit argument.

If there upperlimit is supplied, the function calculates:

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:

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