Microsoft Office Tutorials and References
In Depth Information
NA
NA NA returns the error value associated with #NA .
=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
cell has.
=TYPE(value)
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.
VALUE
The values in the following table show the values and the return results based on the VALUE
reference.
Table 7.6
Return Results of TYPE
If the Value Is…
Returns the Result
Number
1
Text
2
Logical Value
4
Formula
8
Error Value
16
Array
64
Search JabSto ::




Custom Search