Topic 24: Introducing: Excel 2007 CELL Function

[seema]

The Excel 2007 CELL function is one of a group of “Information Functions” that can be used to return information about the formatting, location, or contents of a specific cell.

So, the CELL function's job is to give out information about a cell such as its formatting, the type of data it contains, and whether or not the cell is locked or protected. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can usethe CELL function.

The syntax for the CELL function is:

= CELL (info_type, [reference])
info_type - the type of cell information you want to return. It’s a text value.

Reference (optional) - the cell reference that is being checked. If omitted, the information specified in the info_type argument is returned.

Similar Threads:

• Topic 21: Example Using the Excel 2007 PRODUCT Function
• Topic 19: Do You Really Know the Excel 2007 Function?
• Topic 11: Discover The Excel Cell Alignment Options
• Topic 3: Is There Something New About Excel 2007 Ribbon?
• Topic 36: Excel Text Concatenation: How to Join Multiple Cell Together?

[seema]

To use the Excel 2007 CELL function

Open an Excel spreadsheet and enter a number, such as " 88 ", into cell C2. Click on cell D2 - the location where the results will be displayed. Click on the Formulas tab.

[seema]

From the Function Library group, click the More Functions icon, then point to Information and click on CELL in the list to bring up that function's dialog box. On the Info_type line, enter the word "type". On the Reference line, click on cell C2 in the spreadsheet to enter the cell reference into the dialog box. Click OK. The letter " v " should appear in cell D2 to indicate that the data in the cell is a value. When you click on cell D1, the complete function = CELL("type",D2) appears in the formula bar. Note: If cell C2 contained a word of text, the letter " l " would appear in cell D2 to indicate that the cell contained a label. If cell C2 contained a date, the letter " v " would appear in cell D2 to indicate that the cell contained a value - dates are often considered to be values in Excel. If cell C2 was empty, the letter " b " would appear in cell D2 to indicate that the cell was blank.