Advanced Excel Functions 简明教程

Advanced Excel - Engineering Functions

Excel 工程函数执行最常用的工程计算，其中许多与贝塞尔函数、复数或不同进制之间的转换有关。

The Excel Engineering functions perform the most commonly used Engineering calculations, many of which relate to Bessel functions, complex numbers, or converting between different bases.

Engineering Functions

下表列出了所有工程函数−

The following table lists all the Engineering functions −

S.No.	Function and Description
1	BESSELIReturns the modified Bessel function In(x)
2	BESSELJReturns the Bessel function Jn(x)
3	BESSELKReturns the modified Bessel function Kn(x)
4	BESSELYReturns the Bessel function Yn(x)
5	BIN2DECConverts a binary number to decimal
6	BIN2HEXConverts a binary number to hexadecimal
7	BIN2OCTConverts a binary number to octal
8	BITANDReturns a 'Bitwise And' of two numbers
9	BITLSHIFTReturns a value number shifted left by shift_amount bits
10	BITORReturns a bitwise OR of 2 numbers
11	BITRSHIFTReturns a value number shifted right by shift_amount bits
12	BITXORReturns a bitwise 'Exclusive Or' of two numbers
13	COMPLEXConverts real and imaginary coefficients into a complex number
14	CONVERTConverts a number from one measurement system to another
15	DEC2BINConverts a decimal number to binary
16	DEC2HEXConverts a decimal number to hexadecimal
17	DEC2OCTConverts a decimal number to octal
18	DELTATests whether two values are equal
19	ERFReturns the error function
20	ERF.PRECISEReturns the error function
21	ERFCReturns the complementary error function
22	ERFC.PRECISEReturns the complementary error function
23	GESTEPTests whether a number is greater than a threshold value
24	HEX2BINConverts a hexadecimal number to binary
25	HEX2DECConverts a hexadecimal number to decimal
26	HEX2OCTConverts a hexadecimal number to octal
27	IMABSReturns the absolute value (modulus) of a complex number
28	IMAGINARYReturns the imaginary coefficient of a complex number
29	IMARGUMENTReturns the argument theta, an angle expressed in radians
30	IMCONJUGATEReturns the complex conjugate of a complex number
31	IMCOSReturns the cosine of a complex number
32	IMCOSHReturns the hyperbolic cosine of a complex number
33	IMCOTReturns the cotangent of a complex number
34	IMCSCReturns the cosecant of a complex number
35	IMCSCHReturns the hyperbolic cosecant of a complex number
36	IMDIVReturns the quotient of two complex numbers
37	IMEXPReturns the exponential of a complex number
38	IMLNReturns the natural logarithm of a complex number
39	IMLOG2Returns the base-2 logarithm of a complex number
40	IMLOG10Returns the base-10 logarithm of a complex number
41	IMPOWERReturns a complex number raised to an integer power
42	IMPRODUCTReturns the product of complex numbers
43	IMREALReturns the real coefficient of a complex number
44	IMSECReturns the secant of a complex number
45	IMSECHReturns the hyperbolic secant of a complex number
46	IMSINReturns the sine of a complex number
47	IMSINHReturns the hyperbolic sine of a complex number
48	IMSQRTReturns the square root of a complex number
49	IMSUBReturns the difference of two complex numbers
50	IMSUMReturns the sum of complex numbers
51	IMTANReturns the tangent of a complex number
52	OCT2BINConverts an octal number to binary
53	OCT2DECConverts an octal number to decimal
54	OCT2HEXConverts an octal number to hexadecimal