{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
Application of Excel function tutorials explain the information function (with examples)
Finishing by: Date:2009-04-11 12:58:02 Popularity: Tags:tutorials

eight, to return to the error value # N / A a function of NA

NA function returns an error value for the # N / A. Error value # N / A said, "can not be valid." Recommend the use of NA sign a blank cell. In the absence of the contents of the cell type # N / A, to avoid accidentally including the blank cell of the issues arising from (when the formula contains a reference to the # N / A cells, it will return an error value # N / A).

Its grammatical form of NA ().

It must be noted that after the function name must include the parentheses, or else, Microsoft Excel does not recognize the function. Can also be directly in the cell type # N / A. NA function is provided with other compatible spreadsheet program.

nine, to return to the type of function values TYPE

TYPE function can be used to return the type of value. When a result of a function depend on the particular cell type of the value to use function TYPE. Its grammatical form of TYPE (value) which can be arbitrary Value Value Microsoft Excel, such as figures, text and logical values and so on.

To note that when using different types of data to accept the function (for example, and the function ARGUMENT function INPUT), the function is very useful TYPE. TYPE function can be used to find the function or formula to return to the type of data. TYPE can be used to determine whether the cell contains the formula. TYPE identified only shows the type or value. If a value is a cell reference, it quoted another cell containing the formula, then this formula will return TYPE value of the type of results.


Figure 11

the above, we have the information function Excel function to do a more or less understanding. Information function is used to return to the cell specific or regional information, such as, for example, the cell content, format, number of functions, such as a class. In practice, usually with the logical IF function to achieve in line with the use of information on the determination of the cell.
there isArticle InformationsComment Information
Category column

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