{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
engineering applications Excel function tutorials function explain (with examples)
Finishing by: Date:2009-04-11 12:51:33 Popularity: Tags:tutorials

5, with the integral operator with the ERF function ERFC
ERF error function for the return in points between the upper and lower limits.
The form of its syntax: ERF (lower_limit, upper_limit) which, Lower_limit integral function for the lower limit of ERF. ERF function Upper_limit points for the upper limit. If omitted, the default is zero.
ERFC to return from x to ¡Þ (infinity) function points the remainder of the ERF error function. The form of its syntax:
ERFC (x) in which X is the lower limit of ERF function points.
6, with the function of the complex computing
Still remember the high school you learn the plural? Is not also remember that the plural of die, such as for the calculation of the complex? Excel function to provide the project with the plural of a variety of computing-related function, you can use it to verify its accuracy ah computing. What are the functions on the operation and the plural, and can be attached to Form View. There will be a simple example of how to use function. Function noted in the works for some prefix im a function of it? These are complex operations and related functions.
For example, the plural of known 5 +12 i, please use functions to solve the complex conjugate of the complex, real coefficients, imaginary coefficient, molds.


Figure 4

Schedule: Excel function works
function name Function Description grammatical form
BESSELI amended Bessel function return value, it is purely imaginary parameters used when computing the value of the Bessel function the same. BESSELI (x, n)
BESSELJ return Bessel function. BESSELJ (x, n)
BESSELK amended Bessel function return value, it is purely imaginary parameters used when computing the value of the Bessel function the same. BESSELK (x, n)
BESSELY return Bessel function, also known as the Weber or Neumann function function. BESSELY (x, n)
BIN2DEC to convert binary number as a decimal number. BIN2DEC (number)
BIN2HEX to binary number is converted to hexadecimal. BIN2HEX (number, places)
BIN2OCT will be converted to binary octal number. BIN2OCT (number, places)
COMPLEX the real and imaginary coefficients into a factor of x + yi or x + yj the plural form. COMPLEX (real_num, i_num, suffix)
CONVERT digital conversion from one measurement to another measurement system. CONVERT (number, from_unit, to_unit)
DEC2BIN convert a decimal number to binary number. DEC2BIN (number, places)
DEC2HEX convert a decimal number to hexadecimal number. DEC2HEX (number, places)
DEC2OCT convert a decimal number to octal number. DEC2OCT (number, places)
DELTA test whether the two values equal. If number1 = number2, then return 1, otherwise return 0. DELTA (number1, number2)
ERF return error function in the points between the upper and lower limits. ERF (lower_limit, upper_limit)
ERFC return from x to ¡Þ (infinity) function points the remainder of the ERF error function ERFC (x)
GESTEP If Number greater than or equal to step, to return 1, otherwise return 0. The use of the data filtering function. GESTEP (number, step)
HEX2BIN hexadecimal number will be converted to binary. HEX2BIN (number, places)
HEX2DEC hexadecimal number will be converted to a decimal number. HEX2DEC (number)
HEX2OCT number will be converted to hexadecimal octal number. HEX2OCT (number, places)
IMABS return to x + yi or x + yj text format that the absolute value of the plural (die). IMABS (inumber)
IMAGINARY return to x + yi or x + yj text format of the virtual coefficient of the plural. IMAGINARY (inumber)
IMARGUMENT return to that angle radian IMARGUMENT (inumber)
IMCONJUGATE return to x + yi or x + yj text format Conjugate plural plural. IMCONJUGATE (inumber)
IMCOS return to x + yi or x + yj text format of the cosine of the complex. IMCOS (inumber)
IMDIV return to x + yi or x + yj text format that the two complex business. IMDIV (inumber1, inumber2)
IMEXP return to x + yi or x + yj text format that the index of the plural. IMEXP (inumber)
IMLN return to x + yi or x + yj text format that the plural of the natural logarithm. IMLN (inumber)
IMLOG10 return to x + yi or x + yj text format common to the plural number (to 10 for the base). IMLOG10 (inumber)
IMLOG2 return to x + yi or x + yj text format to the plural base 2 logarithm. IMLOG2 (inumber)
IMPOWER return to x + yi or x + yj text format the n th power complex. IMPOWER (inumber, number)
IMPRODUCT return to x + yi or x + yj text format 2-29 complex product. IMPRODUCT (inumber1, inumber2 ,...)
IMREAL return to x + yi or x + yj text format that is the plural coefficient. IMREAL (inumber)
IMSIN return to x + yi or x + yj text format of the sine value of the plural. IMSIN (inumber)
IMSQRT return to x + yi or x + yj text format that the square root of the complex. IMSQRT (inumber)
IMSUB return to x + yi or x + yj text format the difference between the two plural. IMSUB (inumber1, inumber2)
IMSUM return to x + yi or x + yj text format two or more plural and. IMSUM (inumber1, inumber2 ,...)
OCT2BIN octal number will be converted to binary. OCT2BIN (number, places)
OCT2DEC octal number will be converted to a decimal number. OCT2DEC (number)
OCT2HEX octal number to hexadecimal number conversion. OCT2HEX (number, places)

HomePrevious12345NextEnd
Previous:Application of Excel function tutorials explain the external function (with examples)
Next:Application of Excel function tutorials explain financial functions (with examples)
there isArticle InformationsComment Information
Category column
Ranking Information
Related Articles
Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1