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
Cells can store all sorts of information that can be formatted and displayed in a myriad of ways. If you want to quickly get to the value stored within the cell, you can use the N worksheet function.

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.