Excel Engineering functions

This article about the introduction of Excel engineering functions

1.BESSELI

Purpose: Returns the value of the modified Bessel function, which is equal to the value of the Bessel function when operating with pure imaginary parameters.

Syntax: BesselI (x,n)

Parameter: x is the parameter value. n is the order of the function. If n is not an integer, the truncation is rounded.

2.BESSELJ

Purpose: Returns the value of the Bessel function.

Syntax: BesselJ (x,n)

Parameters: Ditto

3.BESSELK

Purpose: Returns the value of the modified Bessel function, which is equal to the value of the Bessel function when operating with pure imaginary parameters.

Syntax: Besselk (x,n)

Parameters: Ditto

4.BESSELY

Purpose: Returns the Bessel function value, also called the Weber function or the Neumann function.

Syntax: bessely (x,n)

Parameters: Ditto

5.bin2dec

Purpose: Converts a binary number to a decimal number.

Syntax: Bin2dec (number)

Parameter: Number of binary to be converted. Number cannot have more than 10 digits (bits), the highest bit is the symbol bit, and the latter 9 digits are digits. Negative numbers are expressed in binary number complement.

6.bin2hex

Purpose: Converts a binary number to a hexadecimal number.

Syntax: Bin2Hex (number,places)

Parameter: number is the binary that is to be converted. Number cannot have more than 10 digits (bits), the highest bit is the symbol bit, and the latter 9 digits are digits. The negative numbers are represented by the binary number complement; Places is the number of characters you want to use. If places is omitted, the function dec2bin is represented by the fewest characters that can represent this number.

7.bin2oct

Purpose: Converts binary numbers to octal numbers.

Syntax: Bin2oct (number,places)

Parameter: number is the binary that is to be converted; Places is the number of characters you want to use.

8.COMPLEX

Use: Converts real coefficients and virtual coefficients into complex numbers in the form of X+yi or X+yj.

Syntax: COMPLEX (Real_num,i_num,suffix)

Parameters: Real_num is the real part of the complex number, I_num is the imaginary part of the complex number, suffix is the suffix of the imaginary part in the complex number, and it is considered as I when omitted.

9.CONVERT

Purpose: Converts a number from one metric system to another.

Syntax: CONVERT (Number,from_unit,to_unit)

Parameter: number is a numeric value that needs to be converted in from_units. From_unit is the unit of numeric number. To_unit is the unit of the result.

10.dec2bin

Purpose: Converts a decimal number to a binary number.

Syntax: Dec2bin (number,places)

Parameter: number is the decimal that is to be converted. Places is the number of characters to use, and if places is omitted, the function dec2oct is represented by the fewest characters that can represent this number.

11.dec2hex

Purpose: Converts a decimal number to a hexadecimal number.

Syntax: Dec2hex (number,places)

Parameter: number is the decimal that is to be converted. If the argument number is a negative number, the places is omitted. Places is the number of characters you want to use.

12.dec2oct

Purpose: Converts decimal numbers to octal numbers.

Syntax: Dec2oct (number,places)

Parameter: number is the decimal that is to be converted. If the argument number is a negative number, the places is omitted. Places is the number of characters you want to use.

13.DELTA

Purpose: Test whether two values are equal. If number1=number2, it returns 1, otherwise it returns 0.

Syntax: DELTA (NUMBER1,NUMBER2)

Parameter: Number1 is the first parameter. Number2 is the second parameter. If omitted, assume that the value of Number2 is zero.

14.ERF

Purpose: Returns the integral between the upper and lower bounds of the error function.

Syntax: ERF (LOWER_LIMIT,UPPER_LIMIT)

Parameter: Lower_limit is the lower integral of the ERF function. Upper_limit is the integral upper limit of the ERF function. If omitted, the ERF will be integrated between the 0 and the lower bound.

15.ERFC

Use: Returns the residual error function of the ERF function from X to ∞ (infinity) integrals

Syntax: ERFC (x)

Parameters: X? is the lower bound of the integral of the ERF function.

16.GESTEP

Usage: If number is greater than or equal to step, return 1 or 0. Use this function to filter data.

Syntax: Gestep (NUMBER,STEP)

Parameter: number is the value to be tested. Step is the threshold value. If you omit step, the function Gestep assumes it is zero.

17.hex2bin

Purpose: Converts a hexadecimal number to a binary number.

Syntax: Hex2bin (number,places)

Parameter: number is the hexadecimal number to convert, places is the count of characters to use.

18.hex2dec

Purpose: Converts a hexadecimal number to a decimal number.

Syntax: Hex2dec (number)

Parameter: number is the hexadecimal count to convert. The number of digits cannot be more than 10 digits (40-bit binary), the highest bit is the symbol bit, and the remaining 39 digits are digits. Negative numbers are represented by the complement of binary numbers.

19.hex2oct

Purpose: Converts a hexadecimal number to an octal number.

Syntax: Hex2oct (number,places)

Parameter: number is the hexadecimal number to convert, places is the count of characters to use.

20.IMABS

Purpose: Returns the absolute value (modulo) of the complex number represented in X+yi or x+yj text format.

Syntax: Imabs (Inumber)

Parameter: Inumber? is the complex number whose absolute value you want to calculate.

21.IMAGINARY

Purpose: Returns the virtual factor of a complex number expressed in X+yi or x+yj text format.

Syntax: Imaginary (Inumber)

Parameter: Inumber? is the complex number whose virtual coefficients you want to compute.

22.IMARGUMENT

Purpose: Returns the angle in radians.

Syntax: Imargument (Inumber)

Parameters: Inumber is the complex number used to calculate the angle value.