Microsoft Office Tutorials and References
In Depth Information
NA NA returns the error value associated with #NA .
As with the N function, the NA function is generally not needed by Excel and is provided for
compatibility with other spreadsheet programs. You could use the NA function to return #N/A
(no value is available) or you could simply type #N/A into the cell.
TYP Use TYPE when the behavior of another function depends on the type of value a particular
The TYPE function is primarily used when using functions that can accept several different
types of data. Use type to find out the type of data that is returned by the particular function
or cell. Notice the return result as shown in Table 7.6.
This is the value you want converted.
The values in the following table show the values and the return results based on the VALUE
Return Results of TYPE
If the Value Is…
Returns the Result