Skip to content

Excel functions · 54 functions

Excel engineering functions

Unit conversion, binary / octal / hexadecimal conversions, bitwise operations, complex numbers, the error function and Bessel functions.

All functions

  • BESSELI

    Modified Bessel function In(x).

    =BESSELI(x, n)
  • BESSELJ

    Bessel function Jn(x).

    =BESSELJ(x, n)
  • BESSELK

    Modified Bessel function Kn(x).

    =BESSELK(x, n)
  • BESSELY

    Bessel function Yn(x).

    =BESSELY(x, n)
  • BIN2DEC

    Converts a base-2 number to base 10.

    =BIN2DEC(number)
  • BIN2HEX

    Converts a base-2 number to base 16.

    =BIN2HEX(number, [places])
  • BIN2OCT

    Converts a base-2 number to base 8.

    =BIN2OCT(number, [places])
  • BITANDBİTVE

    Bitwise AND.

    =BITAND(number1, number2)
  • BITLSHIFTBİTSOLAKAYDIR

    Shifts bits left.

    =BITLSHIFT(number, shift_amount)
  • BITORBİTVEYA

    Bitwise OR.

    =BITOR(number1, number2)
  • BITRSHIFTBİTSAĞAKAYDIR

    Shifts bits right.

    =BITRSHIFT(number, shift_amount)
  • BITXORBİTÖZELVEYA

    Bitwise XOR.

    =BITXOR(number1, number2)
  • COMPLEXKARMAŞIK

    Builds a complex number from real and imaginary parts.

    =COMPLEX(real_num, i_num, [suffix])
  • CONVERTÇEVİR

    Converts between units.

    =CONVERT(number, from_unit, to_unit)
  • DEC2BIN

    Converts a base-10 number to base 2.

    =DEC2BIN(number, [places])
  • DEC2HEX

    Converts a base-10 number to base 16.

    =DEC2HEX(number, [places])
  • DEC2OCT

    Converts a base-10 number to base 8.

    =DEC2OCT(number, [places])
  • DELTA

    1 if two numbers are equal.

    =DELTA(number1, [number2])
  • ERFHATAİŞLEV

    Error function.

    =ERF(lower_limit, [upper_limit])
  • ERF.PRECISEHATAİŞLEV.DUYARLI

    Error function.

    =ERF.PRECISE(x)
  • ERFCTÜMHATAİŞLEV

    Complementary error function.

    =ERFC(x)
  • ERFC.PRECISETÜMHATAİŞLEV.DUYARLI

    Complementary error function.

    =ERFC.PRECISE(x)
  • GESTEPBESINIR

    1 if a number is at least a threshold.

    =GESTEP(number, [step])
  • HEX2BIN

    Converts a base-16 number to base 2.

    =HEX2BIN(number, [places])
  • HEX2DEC

    Converts a base-16 number to base 10.

    =HEX2DEC(number)
  • HEX2OCT

    Converts a base-16 number to base 8.

    =HEX2OCT(number, [places])
  • IMABSSANMUTLAK

    Absolute value (modulus) of a complex number.

    =IMABS(inumber)
  • IMAGINARYSANAL

    Imaginary coefficient.

    =IMAGINARY(inumber)
  • IMARGUMENTSANBAĞ_DEĞİŞKEN

    Argument (angle in radians).

    =IMARGUMENT(inumber)
  • IMCONJUGATESANEŞLENEK

    Complex conjugate.

    =IMCONJUGATE(inumber)
  • IMCOSSANCOS

    Complex cosine.

    =IMCOS(inumber)
  • IMCOSHSANCOSH

    Complex hyperbolic cosine.

    =IMCOSH(inumber)
  • IMCOTSANCOT

    Complex cotangent.

    =IMCOT(inumber)
  • IMCSCSANCSC

    Complex cosecant.

    =IMCSC(inumber)
  • IMCSCHSANCSCH

    Complex hyperbolic cosecant.

    =IMCSCH(inumber)
  • IMDIVSANBÖL

    Quotient of two complex numbers.

    =IMDIV(inumber1, inumber2)
  • IMEXPSANÜS

    Complex exponential.

    =IMEXP(inumber)
  • IMLNSANLN

    Complex natural logarithm.

    =IMLN(inumber)
  • IMLOG10SANLOG10

    Complex base-10 logarithm.

    =IMLOG10(inumber)
  • IMLOG2SANLOG2

    Complex base-2 logarithm.

    =IMLOG2(inumber)
  • IMPOWERSANKUVVET

    Complex number raised to a power.

    =IMPOWER(inumber, number)
  • IMPRODUCTSANÇARP

    Product of complex numbers.

    =IMPRODUCT(inumber1, [inumber2], ...)
  • IMREALSANGERÇEK

    Real coefficient.

    =IMREAL(inumber)
  • IMSECSANSEC

    Complex secant.

    =IMSEC(inumber)
  • IMSECHSANSECH

    Complex hyperbolic secant.

    =IMSECH(inumber)
  • IMSINSANSIN

    Complex sine.

    =IMSIN(inumber)
  • IMSINHSANSINH

    Complex hyperbolic sine.

    =IMSINH(inumber)
  • IMSQRTSANKAREKÖK

    Complex square root.

    =IMSQRT(inumber)
  • IMSUBSANTOPLA

    Difference of two complex numbers.

    =IMSUB(inumber1, inumber2)
  • IMSUMSANÇIKAR

    Sum of complex numbers.

    =IMSUM(inumber1, [inumber2], ...)
  • IMTANSANTAN

    Complex tangent.

    =IMTAN(inumber)
  • OCT2BIN

    Converts a base-8 number to base 2.

    =OCT2BIN(number, [places])
  • OCT2DEC

    Converts a base-8 number to base 10.

    =OCT2DEC(number)
  • OCT2HEX

    Converts a base-8 number to base 16.

    =OCT2HEX(number, [places])

Excel functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free