Thread: MS Excel 2007 Lecture # 25
MS Excel 2007 Lecture # 25
"Excel 2007 CELL Function"
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.
- 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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)