Microsoft Office Tutorials and References
In Depth Information
CHAPTER 7 Information Functions
7
CHAPTER
Information Functions
Information Functions Overview
Information functions generally are made up of logical results and can be used
in many business situations. Combined with other functions, the information
functions can manage lists of data and provide feedback based on a logical
result. An example of this is: if you were tracking dates where certain items
were received and then delivered, you could use the ISBLANK function combined
with the IF function to return the result. For a more in-depth explanation of this,
see the example for ISBLANK .
The following information functions are discussed in this chapter.
CELL
ISNA
COUNTBLANK
ISNONTEXT
ERROR.TYPE
ISNUMBER
INFO
ISODD
IS
ISREF
ISBLANK
ISTEXT
ISERR
N
ISERROR
NA
ISEVEN
TYPE
ISLOGICAL
Search JabSto ::




Custom Search