{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


Second, the classification function works
In the Excel help system engineering function will generally be divided into three types, namely:
(1) of the function to deal with plural
(2) in different digital systems (such as the decimal system, hexadecimal system, octal and binary system) the conversion between a function of numerical
(3) in different numerical metric system conversion function
In the text in order to more clearly explain the function, the author function to the project is divided into the following six types, namely:
(1) Bessel (Bessel) function
(2) of the digital system in different numerical conversion between a function of
(3) function to filter data
(4) transfer function of weights and measures
(5) and computing the integral function
(6) of the function to deal with plural
For each of the following function to introduce these projects.

1, Bessel (Bessel) function
Bessel (Bessel) function is a special function in the most widely used of a function, in the study of theoretical physics, applied mathematics, atmospheric science and engineering fields, such as radio range of applications. In Excel to provide a total of four functions, namely: BESSELI, BESSELJ, BESSELK, BESSELY.
Grammatical form is: function (x, n) which, X for the parameter values, N for the function of the order. If non-integer n, then rounded truncation. Need to be understood that, if non-numeric x, the Bessel (Bessel) function returns the error value # VALUE!. If a non-numeric n, the Bessel (Bessel) function returns the error value # VALUE!. If n <0, the Bessel (Bessel) function returns the error value # NUM!.

2, the digital system in different numerical conversion between a function of
Excel function works to provide binary, octal, decimal and hexadecimal values between the transfer function.
Function name of such projects is very easy to remember, remember as long as the binary for the BIN, octal for the OCT, the metric system for the DEC, to hex HEX. Function name and then remember that the middle digit 2 will be easy to remember these values the transfer function. For example, if the need for binary to decimal conversion, the application of the function in front of BIN, the middle of 2, the back for the DEC, this function is combined BIN2DEC.
A simple list:


Figure 2

Numerical transfer function of such grammatical form is also very easy to remember.
For example, different decimal to hexadecimal values of grammatical form as follows: function (number), of which Number to be converted to a hexadecimal number.
In another example, the conversion will be different for other hexadecimal notation of the numerical form of the syntax: function (number, places) to be Number One in the number of conversions. Places for the number of characters to use. When the need to return to pre-zero value is particularly useful places.
there isArticle InformationsComment Information
Category column

Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1