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])
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