Exploring Excel's Functions Part 3: CELL() Shocked
- Feb 3, 2006
- Debugging 101 for Visual Studio
- Fun with Fractals in Visual Studio .NET
- Exploring Excel Functions, Part 9: Analyzing Frequency Distributions
- File Management in .NET
- Exploring Excel Functions 8: Predicting the Future
- Exploring Excel's Functions, Part 7: Rounding with Excel
- Binary File Access in the .NET Framework
- Text File Access in the .NET Framework
- Using Geometric Transforms for Text Effects in .NET
- Understanding MDI Applications in .NET
- A .NET Framework Text and Font Primer
- Exploring Excel's Functions, Part 6: TTEST() Function
- Troubleshooting Excel PivotTables
- Troubleshooting Word Tables
- Exploring Excel's Functions, Part 5: The Power of Choice
- Seven Things I Hate About Word Printing
- Exploring Excel's Functions, Part 4: Database Functions
- Exploring Excel's Functions Part 3: CELL() Shocked
- Exploring Excel's Functions Part 2: ADDRESS() and INDIRECT()
- Exploring Excel's Functions: IF() Only!
- Advanced Find-and-Replace Tools in Word
- Going Beyond Basic Spaces and Hyphens in Word
- Get Organized with Word's Outline Tools
- Managing Your Money in Microsoft Excel: Basic Financial Calculations
- Structured Exception Handling in Visual Studio .NET
- Multithreading with the .NET Framework
- .NET Tools for Working with XML
- Storing Information: Variables and Constants in C
- Introducing Web Programming with .NET
- Using Web Forms
- Introducing Web Services
- XML and the .NET Framework
- ASP.NET Programming: Using Web Forms
- Understanding the Common Features of Web Controls
Sams Teach Yourself C in 21 Days, Adobe Reader, 5th Edition
Manage Your Money and Investments with Microsoft Excel
Sams Teach Yourself C in 21 Days, 6th Edition
Sams Teach Yourself C in 21 Days, Adobe Reader, 6th Edition
Sams Teach Yourself Visual Basic .NET Web Programming in 21 Days
Sams Teach Yourself Visual Basic .NET Web Programming in 21 Days, Adobe Reader
Sams Teach Yourself C# Web Programming in 21 Days
Sams Teach Yourself C# Web Programming in 21 Days, Adobe Reader
Sorry, this author hasn't posted any blogs.
From the author of
Manage Your Money and Investments with Microsoft Excel
You might guess that the CELL() function has something to do with worksheet cells—but exactly what? It is one of Excel’s information functions, so-called because their job is to provide information about certain aspects of the worksheet.
A Hard Cell
The CELL() function can tell you a lot of things about a specified worksheet cell. It needs two pieces of information to work, and the syntax is as follows:
CELL(info_type, reference)
Reference tells the function which cell you are interested in. It can be a cell address or range name. If reference refers to a range of more than one cells, CELL() returns information about the top-left cell in the range.
Info_type is a text value that tells the function what information you want. The following table gives all the possibilities. Some of them will be explained in more detail later in the article.
|
Value of Info_type |
Information Returned by CELL() |
|
"address" |
The address of the cell as an absolute cell reference (for example, $A$2). |
|
"col" |
The column number of the cell. |
|
"color" |
1 if the cell is formatted to display negative values in color; 0 otherwise. |
|
"contents" |
The contents of the cell. If the cell contains a formula, the result is returned, not the formula itself. |
|
"filename" |
The filename, including path, and sheet name where the cell is located. The workbook must have been saved for this option to work. |
|
"format" |
A text value indicating the number format applied to the cell. For example, "G" is returned for General format, and "D3" for the mmm-yy date format. See Excel help for a complete listing of return values. |
|
"parentheses" |
1 if the cell is formatted with parentheses for positive or all values; 0 otherwise. |
|
"prefix" |
Text value corresponding to the label alignment prefix of the cell. Returns a single quotation mark (’) if the cell contains left-aligned text, double quotation mark (") if the cell contains right-aligned text, caret (^) if the cell contains centered text, backslash (\) if the cell contains fill-aligned text, and empty text ("") if the cell contains anything else. |
|
"protect" |
1 if the cell is locked; 0 if it is not locked |
|
"row" |
The row number of the cell. |
|
"type" |
Text value indicating the type of data in the cell. Returns "b" if the cell is empty, "l" if the cell contains text, and "v" for anything else (numbers, formulas, and so on). |
|
"width" |
The width of the cell, rounded to an integer, expressed as number of characters in the default font size. |
You can see that the CELL() function is quite flexible, but is there anything really useful you can use it for? Oh yes! Let’s look at some specific examples.
Account Sign In
View your cart