Results 1 to 3 of 3

Thread: Topic 24: Introducing: Excel 2007 CELL Function

  1. #1
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10

    Topic 24: Introducing: Excel 2007 CELL Function

    Advertisement

    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]) Advertisement

    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.

  2. #2
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    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.


  3. #3
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    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.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •