|
Excel Engineering Functions
Home »
Excel-Built-In-Functions »
Excel-Engineering-Functions
Search this site:
The built-in Excel Engineering Functions have been provided to perform some of the commonly used
engineering calculations, many of which relate to Bessel Functions, Complex Numbers or converting
between different bases. Engineers will also find the
Excel Math and Trig functions
useful.
The tables below list all the Excel Engineering functions, grouped into categories, to help you to
find the function you need. Note that some of the functions are new to Excel 2010, so are not available
in earlier versions of Excel. Selecting a function name will take you to a full description of the
function with examples of use.
Excel Engineering Functions List
|
Converting Between Units of Measurement
|
|
CONVERT
|
Converts a number from one measurement system to another
|
|
Bessel Functions
|
|
BESSELI
|
Calculates the modified Bessel function In(x)
|
|
BESSELJ
|
Calculates the Bessel function Jn(x)
|
|
BESSELK
|
Calculates the modified Bessel function Kn(x)
|
|
BESSELY
|
Calculates the modified Bessel function Yn(x)
|
|
Converting Between Bases
|
|
BIN2DEC
|
Converts a binary number to a decimal
|
|
BIN2HEX
|
Converts a binary number to hexadecimal
|
|
BIN2OCT
|
Converts a binary number to octal
|
|
DEC2BIN
|
Converts a decimal number to binary
|
|
DEC2HEX
|
Converts a decimal number to hexadecimal
|
|
DEC2OCT
|
Converts a decimal number to octal
|
|
HEX2BIN
|
Converts a hexadecimal number to binary
|
|
HEX2DEC
|
Converts a hexadecimal number to a decimal
|
|
HEX2OCT
|
Converts a hexadecimal number to octal
|
|
OCT2BIN
|
Converts octal number to binary
|
|
OCT2DEC
|
Converts octal number to a decimal
|
|
OCT2HEX
|
Converts octal number to hexadecimal
|
|
The Error Function
|
|
ERF
|
Returns the error function integrated between two supplied limits
|
|
ERF.PRECISE
|
Returns the error function integrated between 0 and a supplied limit
(New in Excel 2010)
|
|
ERFC
|
Returns the complementary error function integrated between a supplied lower limit and infinity
|
|
ERFC.PRECISE
|
Returns the complementary error function integrated between a supplied lower limit and infinity
(New in Excel 2010)
|
|
|
Testing Numeric Values
|
|
DELTA
|
Tests whether two supplied numbers are equal
|
|
GESTEP
|
Tests whether a number is greater than a supplied threshold value
|
|
Complex Numbers
|
|
COMPLEX
|
Converts user-supplied real and imaginary coefficients into a complex number
|
|
IMABS
|
Returns the absolute value (the modulus) of a complex number
|
|
IMAGINARY
|
Returns the imaginary coefficient of a complex number
|
|
IMARGUMENT
|
Returns the argument Θ (an angle expressed in radians) of a complex number
|
|
IMCONJUGATE
|
Returns the complex conjugate of a complex number
|
|
IMCOS
|
Returns the cosine of a complex number
|
|
IMDIV
|
Returns the quotient of two supplied complex numbers
|
|
IMEXP
|
Returns the exponential of a complex number
|
|
IMLN
|
Returns the natural logarithm of a complex number
|
|
IMLOG10
|
Returns the base-10 logarithm of a complex number
|
|
IMLOG2
|
Returns the base-2 logarithm of a complex number
|
|
IMPOWER
|
Calculates a complex number raised to a supplied power
|
|
IMPRODUCT
|
Returns the product of up to 255 supplied complex numbers
|
|
IMREAL
|
Returns the real coefficient of a complex number
|
|
IMSIN
|
Returns the sine of a complex number
|
|
IMSQRT
|
Returns the square root of a complex number
|
|
IMSUB
|
Subtracts two complex numbers
|
|
IMSUM
|
Calculates the sum of two complex numbers
|
|
Analysis Toolpak
If the Excel Engineering functions are not available to you, you will need to install the
analysis toolpak.
To do this in Excel 2003 :
- From the Tools drop-down menu, select the option Add-Ins ...
- An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak and click OK
To do this in Excel 2007 or Excel 2010 :
- Click the Microsoft button on the top left of your spreadsheet and select
the Excel Options button
- From the menu on the left hand side, select Add-Ins
- In the 'Manage:' box, select Excel Add-ins and click Go...
- An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak
and click OK
|
