Contents
An Introduction to Excel Functions
Financial Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and Reference Functions
Database Functions
Text Functions
Logical Functions
Information Functions
Engineering Functions
Cube Functions
Add-In and Automation Functions
|
 |
 |
 |
|
Engineering Functions
Function |
Description |
Syntax |
||
BESSELI |
Returns the modified Bessel
function In(x) |
(x,n) |
||
BESSELJ |
Returns the Bessel function Jn(x) |
(x,n) |
||
BESSELK |
Returns the modified Bessel
function Kn(x) |
(x,n) |
||
BESSELY |
Returns the Bessel function Yn(x) |
(x,n) |
||
BIN2DEC |
Converts a binary number
to decimal |
(number) |
||
BIN2HEX |
Converts a binary number
to hexadecimal |
(number) |
||
BIN2OCT |
Converts a binary number to octal |
(number) |
||
COMPLEX |
Converts real and imaginary
coefficients into a complex number |
(real_num,i_num,suffix) |
||
CONVERT |
Converts a number from one
measurement system to another |
(number,from_unit,
to_unit) |
||
DEC2BIN |
Converts a decimal number
to binary |
(number,places) |
||
DEC2HEX |
Converts a decimal number
to hexadecimal |
(number,places) |
||
DEC2OCT |
Converts a decimal number
to octal |
(number,places) |
||
DELTA |
Tests whether two values are equal |
(number1,number2) |
||
ERF |
Returns the error function |
(lower_limit,upper_limit) |
||
ERFC |
Returns the complementary
error function |
(x) |
||
GESTEP |
Tests whether a number is greater than a threshold value |
(number,step) |
||
HEX2BIN |
Converts a hexadecimal number to binary |
(number,places) |
||
HEX2DEC |
Converts a hexadecimal number to decimal |
(number) |
||
HEX2OCT |
Converts a hexadecimal number to octal |
(number) |
||
IMABS |
Returns the absolute value
(modulus) of a complex number |
(inumber) |
||
IMAGINARY |
Returns the imaginary coefficient of a complex number |
(inumber) |
||
IMARGUMENT |
Returns the argument theta,
an angle expressed in radians |
(inumber) |
||
IMCONJUGATE |
Returns the complex conjugate of a complex number |
(inumber) |
||
IMCOS |
Returns the cosine of a complex number |
(inumber) |
||
IMDIV |
Returns the quotient of two
complex numbers |
(inumber1,inumber2) |
||
IMEXP |
Returns the exponential of a
complex number |
(inumber) |
||
IMLN |
Returns the natural logarithm of a complex number |
(inumber) |
||
IMLOG10 |
Returns the base-10 logarithm of a complex number |
(inumber) |
||
IMLOG2 |
Returns the base-2 logarithm of a complex number |
(inumber) |
||
IMPOWER |
Returns a complex number raised to an integer power |
(inumber,number) |
||
IMPRODUCT |
Returns the product of from 2 to 29 complex numbers |
(inumber1,inumber2,...) |
||
IMREAL |
Returns the real coefficient of a complex number |
(inumber) |
||
IMSIN |
Returns the sine of a complex number |
(inumber) |
||
IMSQRT |
Returns the square root of a
complex number |
(inumber) |
||
IMSUB |
Returns the difference between two complex numbers |
(inumber1,inumber2) |
||
IMSUM |
Returns the sum of complex
numbers |
(inumber1,inumber2,...) |
||
OCT2BIN |
Converts an octal number to binary |
(number,places) |
||
OCT2DEC |
Converts an octal number
to decimal |
(number) |
||
OCT2HEX |
Converts an octal number
to hexadecimal |
(number) |
| Acknowledgments & Disclaimer |
Tags
No one has tagged this page yet... Be the first.. Log in using the link below and return to add your tag
