## 工程公式

关键词:  工程公式

Formulas Description Examples
BESSELI Syntax: BESSELI(X, N)
Returns the modified Bessel function In(x), which is equivalent to the Bessel function evaluated for purely imaginary arguments.
=BESSELI(1.5, 1)
BESSELJ Syntax: BESSELJ(X, N)
Returns the Bessel function Jn(x).
=BESSELJ(1.9, 2)
BESSELK Syntax: BESSELK(X, N)
Returns the modified Bessel function Kn(x)
=BESSELK(1.5, 1)
BESSELY Syntax: BESSELY(X, N)
Returns the Bessel function Yn(x).
=BESSELY(2.5, 1)
BIN2DEC Syntax: BIN2DEC(number)
Converts a binary number to decimal.
=BIN2DEC(101010)
BIN2HEX Syntax: BIN2HEX(number, [places])
Converts a binary number to hexadecimal.
=BIN2HEX(101010, 5)
BIN2OCT Syntax: BIN2OCT(number, [places])
Converts a binary number to octal.
=BIN2OCT(101010)
BITAND Syntax: BITAND(number1, number2)
Returns a bitwise 'AND' of two numbers.
=BITAND(1, 2)
BITOR Syntax: BITOR(number1, number2)
Returns a bitwise 'OR' of two numbers.
=BITOR(1, 2)
BITXOR Syntax: BITXOR(number1, number2)
Returns a bitwise 'XOR' of two numbers.
=BITXOR(1, 2)
BITLSHIFT Syntax: BITLSHIFT(number, shift_number)
Returns a number shifted left by the specified number of bits.
=BITLSHIFT(1, 2)
BITRSHIFT Syntax: BITRSHIFT(number, shift_number)
Returns a number shifted right by the specified number of bits.
=BITRSHIFT(1, 2)
CONVERT Syntax: CONVERT(number, from_unit, to_unit)
This function is used to convert a number from one measurement system to another.
=CONVERT(10, "sg", "g")
DEC2BIN Syntax: DEC2BIN(number, [places])
Converts a decimal number to binary.
=DEC2BIN(9, 4)
DEC2HEX Syntax: DEC2HEX(number, [places])
Converts a decimal number to hexadecimal.
=DEC2HEX(100, 4)
DEC2OCT Syntax: DEC2OCT(number, [places])
Converts a decimal number to octal.
=DEC2OCT(58, 3)
DELTA Syntax: DELTA(number1, [number2])
Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. If omitted, number2 is assumed to be zero.
=DELTA(2, 1)
ERF Syntax: ERF(lower_limit,[upper_limit])
Returns the error function integrated between lower_limit and upper_limit. If upper_limit omitted, ERF integrates between zero and lower_limit.
=ERF(1, 2)
ERFC Syntax: ERFC(lower_limit,[upper_limit])
Returns the complementary error function integrated between lower_limit and upper_limit. If upper_limit omitted, ERF integrates between lower_limit and infinity.
=ERFC(1, 2)
GESTEP Syntax: GESTEP(number,[step])
Returns 1 if number >= step; returns 0 (zero) otherwise. Use this function to filter a set of values.
=GESTEP(1, 2)
HEX2BIN Syntax: HEX2BIN(number, [places])
Converts a hexadecimal number to binary.
=HEX2BIN("F", 8)
HEX2DEC Syntax: HEX2DEC(number)
Converts a hexadecimal number to decimal.
=HEX2DEC("A5")
HEX2OCT Syntax: HEX2OCT(number, [places])
Converts a hexadecimal number to oct.
=HEX2OCT("F", 3)
IMABS Syntax: IMABS(inumber)
Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the absolute value.
=IMABS("3+4i")
IMAGINARY Syntax: IMAGINARY(inumber)
Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the imaginary coefficient.
=IMAGINARY("3+4i")
IMARGUMENT Syntax: IMARGUMENT(inumber)
Returns the argument Theta (theta), an angle expressed in radians.
Inumber is a complex number for which you want the argument Theta.
=IMARGUMENT("3+4i")
IMCOS Syntax: IMCOS(inumber)
Returns the cosine of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the cosine.
=IMCOS("3+4i")
IMCOSH Syntax: IMCOSH(inumber)
Returns the hyperbolic cosine of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the hyperbolic cosine.
=IMCOSH("3+4i")
IMCOT Syntax: IMCOT(inumber)
Returns the cotangent of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the cotangent.
=IMCOT("3+4i")
IMCSC Syntax: IMCSC(inumber)
Returns the cosecant of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the cosecant.
=IMCSC("3+4i")
IMCSCH Syntax: IMCSCH(inumber)
Returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the hyperbolic cosecant.
=IMCSCH("3+4i")
IMCONJUGATE Syntax: IMCONJUGATE(inumber)
Returns the complex conjugate of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the conjugate.
=IMCONJUGATE("3+4i")
IMDIV Syntax: IMDIV(inumber1, inumber2)
Returns the quotient of two complex numbers in x + yi or x + yj text format.
Inumber1 is the complex numerator or dividend. Inumber2 is the complex denominator or divisor.
=IMDIV("3+4i", "2+2i")
IMEXP Syntax: IMEXP(inumber)
Returns the exponential of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the exponential.
=IMEXP("3+4i")
IMLN Syntax: IMLN(inumber)
Returns the natural logarithm of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the natural logarithm.
=IMLN("3+4i")
IMLOG2 Syntax: IMLOG2(inumber)
Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the base-2 logarithm.
=IMLOG2("3+4i")
IMLOG10 Syntax: IMLOG10(inumber)
Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the common logarithm.
=IMLOG10("3+4i")
IMPOWER Syntax: IMPOWER(inumber, number)
Returns a complex number in x + yi or x + yj text format raised to a power.
Inumber is a complex number for which you want to raise to a power. Number is the power to which you want to raise the complex number.
=IMPOWER("3+4i", "2+2i")
IMPRODUCT Syntax: IMPRODUCT(inumber1,inumber2...)
Returns the product of 2 to 29 complex numbers in x + yi or x + yj text format.
Inumber1,inumber2,... are 1 to 29 complex numbers to multiply.
=IMPRODUCT("3+4i", "2+2i")
IMREAL Syntax: IMREAL(inumber)
Returns the real coefficient of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the real coefficient.
=IMREAL("3+4i")
IMSEC Syntax: IMSEC(inumber)
Returns the secant of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the secant.
=IMSEC("3+4i")
IMSECH Syntax: IMSECH(inumber)
Returns the hyperbolic secant of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you hyperbolic secant.
=IMSECH("3+4i")
IMSIN Syntax: IMSIN(inumber)
Returns the sine of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the sine.
=IMSIN("3+4i")
IMSINH Syntax: IMSINH(inumber)
Returns the hyperbolic sine of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the hyperbolic sine.
=IMSINH("3+4i")
IMSQRT Syntax: IMSQRT(inumber1)
Returns the square root of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the square root.
=IMSQRT("3+4i")
IMSUM Syntax: IMSUM(inumber1,inumber2...)
Returns the sum of two or more complex numbers in x + yi or x + yj text format.
Inumber1,inumber2,... are 1 to 29 complex numbers to add.
=IMSUM("3+4i", "2+2i")
IMSUB Syntax: IMSUB(inumber1,inumber2)
Returns the difference of two complex numbers in x + yi or x + yj text format.
Inumber1,inumber2, the complex number from which to subtract.
=IMSUB("3+4i", "2+2i")
IMTAN Syntax: IMTAN(inumber)
Returns the tangent of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the tangent.
=IMTAN("3+4i")
OCT2BIN Syntax: OCT2BIN(number, [places])
Converts an Octal (Base 8) number into a Binary (Base 2) number.
=OCT2BIN("2", 10)
OCT2DEC Syntax: OCT2DEC(number)
Converts an octal number to decimal.
=OCT2DEC(54)
OCT2HEX Syntax: OCT2HEX(number, [places])
Converts an octal number to hexadecimal.
=OCT2HEX(100, 4)