Information Functions

Tips, Tricks, and Answers

The following articles are available for the 'Information Functions' topic. Click the article's title (shown in bold) to see the associated article.

Determining a Value of a Cell
Much of Excel's worksheet data is maintained by internal numbers, regardless of what is displayed on the screen. You can uncover the underlying numbers by using the N worksheet function, described in this tip.

Getting the Name of the Parent Workbook
If you need to insert into a cell the name of the workbook in which a worksheet is contained, you can use the CELL function. This tip explains the proper way to get the info you need.