Excel Engineering Formulas

Functions for engineering calculations: base conversions, complex numbers, and Bessel functions.

54 formulas

2 Beginner

13 Intermediate

39 Advanced

BIN2DEC

=BIN2DEC(number)

BIN2HEX

=BIN2HEX(number, [places])

BIN2OCT

=BIN2OCT(number, [places])

DEC2BIN

=DEC2BIN(number, [places])

DEC2HEX

=DEC2HEX(number, [places])

DEC2OCT

=DEC2OCT(number, [places])

HEX2BIN

=HEX2BIN(number, [places])

HEX2DEC

=HEX2DEC(number)

HEX2OCT

=HEX2OCT(number, [places])

OCT2BIN

=OCT2BIN(number, [places])

OCT2DEC

=OCT2DEC(number)

OCT2HEX

=OCT2HEX(number, [places])

COMPLEX

=COMPLEX(real_num, i_num, [suffix])

IMREAL

=IMREAL(inumber)

IMAGINARY

=IMAGINARY(inumber)

IMABS

=IMABS(inumber)

IMSUM

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

IMPRODUCT

=IMPRODUCT(inumber1, [inumber2], ...)

CONVERT

=CONVERT(number, from_unit, to_unit)

DELTA

=DELTA(number1, [number2])

GESTEP

=GESTEP(number, [step])

BITAND

=BITAND(number1, number2)

BITOR

=BITOR(number1, number2)

BITXOR

=BITXOR(number1, number2)

BITLSHIFT

=BITLSHIFT(number, shift_amount)

BITRSHIFT

=BITRSHIFT(number, shift_amount)

ERF

=ERF(lower_limit, [upper_limit])

ERFC

BESSELI

=BESSELI(x, n)

BESSELJ

=BESSELJ(x, n)

BESSELK

=BESSELK(x, n)

BESSELY

=BESSELY(x, n)

ERF.PRECISE

=ERF.PRECISE(x)

ERFC.PRECISE

=ERFC.PRECISE(x)

IMARGUMENT

=IMARGUMENT(inumber)

IMCONJUGATE

=IMCONJUGATE(inumber)

IMCOS

=IMCOS(inumber)

IMCOSH

=IMCOSH(inumber)

IMCOT

=IMCOT(inumber)

IMCSC

=IMCSC(inumber)

IMCSCH

=IMCSCH(inumber)

IMDIV

=IMDIV(inumber1, inumber2)

IMEXP

=IMEXP(inumber)

IMLN

=IMLN(inumber)

IMLOG10

=IMLOG10(inumber)

IMLOG2

=IMLOG2(inumber)

IMPOWER

=IMPOWER(inumber, number)

IMSEC

=IMSEC(inumber)

IMSECH

=IMSECH(inumber)

IMSIN

=IMSIN(inumber)

IMSINH

=IMSINH(inumber)

IMSQRT

=IMSQRT(inumber)

IMSUB

=IMSUB(inumber1, inumber2)

IMTAN

=IMTAN(inumber)