{oapdf_gg}
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. |