"Excel 2007 CELL Function"

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 use the 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.

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.

• 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.

Related Topics:

Other than Excel 2007 CELL function, you can view the following Excel functions tutorials:

How to Write a Formula in Microsoft Excel 2007?
Knowing the Different Types of Excel 2007 Functions
Using Excel 2007 IF Function to Perform the Calculation That Can Ease Your Daily Related Tasks
Use the Excel 2007 MAX Function to Find a Largest Number in a Series
Guide to Use the NOW Function Correctly in Excel 2007
Demonstration of Using the Date and Time Functions with Excel 2007
Using the Excel 2007 Count Function - Example Demonstration
Use the Microsoft Excel 2007 Product Function to Perform the Calculation
Guide to Use the Excel 2007 Radian Function Correctly

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the Excel 2007 Cell Function info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb