Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791
MS Excel 2007 Lecture # 25
  • The Facebook Platform

Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2010
    Location
    Lahore, Pakistan
    Age
    25
    Posts
    3,818
    Points
    6,772.51
    Rep Power
    10000

    Default 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


    Name:  excel-cell-function.gif
Views: 276
Size:  14.2 KB

    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.

    MS Excel 2007 Lecture # 25-excel-2007-cell-function-arguments.gif


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







    Find Me On Social Networks

    Facebook | Twitter | Google+



 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Tags for this Thread

Posting Permissions

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