Use Of Cell
This is the cell and contents to test.
|
17.50%
| ||
The cell address.
|
$D$3
| ||
The column number.
|
4
| ||
The row number.
|
3
| ||
The actual contents of the cell.
|
0.175
| ||
The type of entry in the cell.
Shown as b for blank, l for text, v for value. |
v
| ||
The alignment of the cell.
Shown as ' for left, ^ for centre, " for right. Nothing is shown for numeric entries. | |||
The width of the cell.
|
12
| ||
The number format fo the cell.
(See the table shown below) |
P2
| ||
Formatted for braces ( ) on positive values.
1 for yes, 0 for no. |
0
| ||
Formatted for coloured negatives.
1 for yes, 0 for no. |
0
| ||
The type of cell protection.
1 for a locked, 0 for unlocked. |
1
| ||
The filename containing the cell.
|
C:\Users\Nitin Pal Singh\Desktop\[Excel Master Sheet.xlsb]CELL
| ||
What Does It Do ?
| |||
This function examines a cell and displays information about the contents, position and formatting.
| |||
Syntax
| |||
=CELL("TypeOfInfoRequired",CellToTest)
| |||
The TypeOfInfoRequired is a text entry which must be surrounded with quotes " ".
| |||
Formatting
| |||
No special formatting is needed.
| |||
Codes used to show the formatting of the cell.
| |||
Numeric Format
|
Code
| ||
General
|
G
| ||
0
|
F0
| ||
#,##0
|
,0
| ||
0.00
|
F2
| ||
#,##0.00
|
,2
| ||
$#,##0_);($#,##0)
|
C0
| ||
$#,##0_);[Red]($#,##0)
|
C0-
| ||
$#,##0.00_);($#,##0.00)
|
C2
| ||
$#,##0.00_);[Red]($#,##0.00)
|
C2-
| ||
0%
|
P0
| ||
0.00%
|
P2
| ||
0.00E+00
|
S2
| ||
# ?/? or # ??/??
|
G
| ||
m/d/yy or m/d/yy h:mm or mm/dd/yy.
|
D4
| ||
d-mmm-yy or dd-mmm-yy
|
D1
| ||
d-mmm or dd-mmm
|
D2
| ||
mmm-yy
|
D3
| ||
mm/dd
|
D5
| ||
h:mm AM/PM
|
D7
| ||
h:mm:ss AM/PM
|
D6
| ||
h:mm
|
D9
| ||
h:mm:ss
|
D8
| ||
Example
| |||
The following example uses the =CELL() function as part of a formula which extracts the filename.
| |||
The name of the current file is :
|
PM5fFetch5f272e112e15.xls
| ||
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें