Microsoft Office Tutorials and References
In Depth Information
Finding What IS and What IS Not
One useful application of the INFO function is to use the returned Excel
version number to determine whether the workbook can use a newer feature.
For example, the ability to work with XML data has only been available in
Excel 2002 and later. By testing the version number, you can be notified
whether you can work with XML data. This formula uses the release choice
as the argument:
=IF(INFO(“release”)>9,”This version can import XML”, “This
version cannot import XML”)
Figure 15-3 shows values returned with the INFO function.
Figure 15-3:
Getting
facts about
the
computer with
the INFO
function.
Here’s how to use the INFO function:
1. Position the cursor in the cell where you want the results to appear.
2. Enter =INFO( to begin the function entry.
3. Enter one of the argument choices listed in Table 15-3.
Make sure to surround it with double quotes (" ").
4. Type a ), and press Enter.
Finding What IS and What IS Not
A handful of IS functions report back a true or false answer about certain cell
characteristics — for example, is a cell blank or does it contain text? These
functions are often used in combination with other functions, typically the IF
function, to handle errors or other unexpected or undesirable results.
Search JabSto ::




Custom Search