Engineering
★ 35 · ◉ 12 · All versions
=CONVERT()
units for the result. CONVERT accepts the following text values (in quotation marks) for from_unit and to_unit.
=CONVERT(number,from_unit,to_unit)
Scientific & Unit Conversion
Engineering
★ 17 · ◉ 11 · All versions
=DEC2HEX()
Converts a decimal number to hexadecimal.
=DEC2HEX(number, [places])
Scientific & Unit Conversion
Engineering
★ 37 · ◉ 11 · All versions
=ERFC()
Returns the complementary ERF function integrated between x and infinity.
=ERFC(x)
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 10 · All versions
=IMCOT()
Returns the cotangent of a complex number in x+yi or x+yj text format.
=IMCOT(inumber)
Scientific & Unit Conversion
Engineering
★ 23 · ◉ 10 · All versions
=IMEXP()
Returns the exponential of a complex number in x + yi or x + yj text format.
=IMEXP(inumber)
Scientific & Unit Conversion
Engineering
★ 34 · ◉ 10 · All versions
=IMLN()
Returns the natural logarithm of a complex number in x + yi or x + yj text format.
=IMLN(inumber)
Scientific & Unit Conversion
Engineering
★ 37 · ◉ 9 · All versions
=BESSELJ()
Returns the Bessel function.
=BESSELJ(X, N)
Scientific & Unit Conversion
Engineering
★ 22 · ◉ 9 · All versions
=BESSELY()
Returns the Bessel function, which is also called the Weber function or the Neumann function.
=BESSELY(X, N)
Scientific & Unit Conversion
Engineering
★ 28 · ◉ 9 · Excel 2013
=BITAND()
Returns a bitwise 'AND' of two numbers.
=BITAND( number1, number2)
Scientific & Unit Conversion
Engineering
★ 28 · ◉ 9 · All versions
=HEX2DEC()
Converts a hexadecimal number to decimal.
=HEX2DEC(number)
Scientific & Unit Conversion
Engineering
★ 17 · ◉ 9 · All versions
=IMLOG10()
Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
=IMLOG10(inumber)
Scientific & Unit Conversion
Engineering
★ 28 · ◉ 9 · All versions
=IMPOWER()
Returns a complex number in x + yi or x + yj text format raised to a power.
=IMPOWER(inumber, number)
Scientific & Unit Conversion
Engineering
★ 15 · ◉ 9 · All versions
=OCT2BIN()
Converts an octal number to binary.
=OCT2BIN(number, [places])
Scientific & Unit Conversion
Engineering
★ 27 · ◉ 8 · All versions
=BIN2DEC()
Converts a binary number to decimal.
=BIN2DEC(number)
Scientific & Unit Conversion
Engineering
★ 44 · ◉ 8 · All versions
=HEX2OCT()
Converts a hexadecimal number to octal.
=HEX2OCT(number, [places])
Scientific & Unit Conversion
Engineering
★ 21 · ◉ 8 · All versions
=IMARGUMENT()
Returns the argument (theta), an angle expressed in radians, such that:
=IMARGUMENT(inumber)
Scientific & Unit Conversion
Engineering
★ 16 · ◉ 8 · All versions
=IMCSCH()
Returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format.
=IMCSCH(inumber)
Scientific & Unit Conversion
Engineering
★ 16 · ◉ 8 · All versions
=IMSEC()
Returns the secant of a complex number in x+yi or x+yj text format.
=IMSEC(inumber)
Scientific & Unit Conversion
Engineering
★ 25 · ◉ 8 · All versions
=IMSUM()
Returns the sum of two or more complex numbers in x + yi or x + yj text format.
=IMSUM(inumber1, [inumber2], ...)
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 7 · All versions
=BIN2HEX()
Converts a binary number to hexadecimal.
=BIN2HEX(number, [places])
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 7 · Excel 2013
=BITOR()
Returns a bitwise 'OR' of two numbers.
=BITOR(number1, number2)
Scientific & Unit Conversion
Engineering
★ 23 · ◉ 7 · Excel 2013
=BITRSHIFT()
Returns a number shifted right by the specified number of bits.
=BITRSHIFT(number, shift_amount)
Scientific & Unit Conversion
Engineering
★ 40 · ◉ 7 · All versions
=COMPLEX()
Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
=COMPLEX(real_num, i_num, [suffix])
Scientific & Unit Conversion
Engineering
★ 16 · ◉ 7 · All versions
=HEX2BIN()
Converts a hexadecimal number to binary.
=HEX2BIN(number, [places])
Scientific & Unit Conversion
Engineering
★ 16 · ◉ 7 · All versions
=IMCONJUGATE()
Returns the complex conjugate of a complex number in x + yi or x + yj text format.
=IMCONJUGATE(inumber)
Scientific & Unit Conversion
Engineering
★ 21 · ◉ 7 · All versions
=IMREAL()
Returns the real coefficient of a complex number in x + yi or x + yj text format.
=IMREAL(inumber)
Scientific & Unit Conversion
Engineering
★ 44 · ◉ 7 · All versions
=IMSQRT()
Returns the square root of a complex number in x + yi or x + yj text format.
=IMSQRT(inumber)
Scientific & Unit Conversion
Engineering
★ 21 · ◉ 7 · All versions
=IMSUB()
Returns the difference of two complex numbers in x + yi or x + yj text format. If you just want to subtract two numbers that are not complex, see Subtract numbers.
=IMSUB(inumber1, inumber2)
Scientific & Unit Conversion
Engineering
★ 43 · ◉ 6 · All versions
=BESSELK()
Returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments.
=BESSELK(X, N)
Scientific & Unit Conversion
Engineering
★ 35 · ◉ 6 · Excel 2013
=BITXOR()
Returns a bitwise 'XOR' of two numbers.
=BITXOR(number1, number2)
Scientific & Unit Conversion
Engineering
★ 36 · ◉ 6 · All versions
=IMABS()
Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.
=IMABS(inumber)
Scientific & Unit Conversion
Engineering
★ 39 · ◉ 6 · All versions
=IMAGINARY()
Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
=IMAGINARY(inumber)
Scientific & Unit Conversion
Engineering
★ 18 · ◉ 6 · All versions
=IMCOSH()
Returns the hyperbolic cosine of a complex number in x+yi or x+yj text format.
=IMCOSH(inumber)
Scientific & Unit Conversion
Engineering
★ 33 · ◉ 6 · All versions
=IMCSC()
Returns the cosecant of a complex number in x+yi or x+yj text format.
=IMCSC(inumber)
Scientific & Unit Conversion
Engineering
★ 38 · ◉ 6 · All versions
=IMDIV()
Returns the quotient of two complex numbers in x + yi or x + yj text format.
=IMDIV(inumber1, inumber2)
Scientific & Unit Conversion
Engineering
★ 37 · ◉ 6 · All versions
=IMPRODUCT()
Returns the product of 1 to 255 complex numbers in x + yi or x + yj text format.
=IMPRODUCT(inumber1, [inumber2], ...)
Scientific & Unit Conversion
Engineering
★ 20 · ◉ 6 · All versions
=IMSECH()
Returns the hyperbolic secant of a complex number in x+yi or x+yj text format.
=IMSECH(inumber)
Scientific & Unit Conversion
Engineering
★ 35 · ◉ 6 · All versions
=IMSINH()
The IMSINH function returns the hyperbolic sine of a complex number in x+yi or x+yj text format.
=IMSINH(inumber)
Scientific & Unit Conversion
Engineering
★ 31 · ◉ 6 · All versions
=OCT2DEC()
Converts an octal number to decimal.
=OCT2DEC(number)
Scientific & Unit Conversion
Engineering
★ 20 · ◉ 5 · All versions
=DEC2BIN()
Converts a decimal number to binary.
=DEC2BIN(number, [places])
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 5 · All versions
=DEC2OCT()
Converts a decimal number to octal.
=DEC2OCT(number, [places])
Scientific & Unit Conversion
Engineering
★ 16 · ◉ 5 · All versions
=IMCOS()
Returns the cosine of a complex number in x + yi or x + yj text format.
=IMCOS(inumber)
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 4 · Excel 2013
=BITLSHIFT()
Returns a number shifted left by the specified number of bits.
=BITLSHIFT(number, shift_amount)
Scientific & Unit Conversion
Engineering
★ 41 · ◉ 4 · All versions
=ERF()
Returns the error function integrated between lower_limit and upper_limit.
=ERF(lower_limit,[upper_limit])
Scientific & Unit Conversion
Engineering
★ 18 · ◉ 4 · All versions
=GESTEP()
Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values. For example, by summing several GESTEP functions you calculate the count of values that exceed a threshold.
=GESTEP(number, [step])
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 4 · All versions
=IMSIN()
Returns the sine of a complex number in x + yi or x + yj text format.
=IMSIN(inumber)
Scientific & Unit Conversion
Engineering
★ 31 · ◉ 3 · All versions
=BESSELI()
Returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments.
=BESSELI(X, N)
Scientific & Unit Conversion
Engineering
★ 43 · ◉ 3 · All versions
=BIN2OCT()
Converts a binary number to octal.
=BIN2OCT(number, [places])
Scientific & Unit Conversion
Engineering
★ 32 · ◉ 3 · All versions
=DELTA()
Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.
=DELTA(number1, [number2])
Scientific & Unit Conversion
Engineering
★ 38 · ◉ 3 · All versions
=IMTAN()
Returns the tangent of a complex number in x+yi or x+yj text format.
=IMTAN(inumber)
Scientific & Unit Conversion
Engineering
★ 21 · ◉ 2 · All versions
=IMLOG2()
Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.
=IMLOG2(inumber)
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 1 · All versions
=OCT2HEX()
Converts an octal number to hexadecimal.
=OCT2HEX(number, [places])
Scientific & Unit Conversion