| Cell Function | ||||
| In Excel, the CELL function can be used to retrieve information about a cell. This can include contents, formatting, size, etc. | ||||
| The syntax for the CELL function is: | ||||
| CELL( type, [range] ) | ||||
| type is the type of information that you'd like to retrieve for the cell. type can be one of the following values: | ||||
| Value | Explanation | |||
| "address" | Address of the cell. If the cell refers to a range, it is the first cell in the range. | |||
| "col" | Column number of the cell. | |||
| "color" | Returns 1 if the color is a negative value; Otherwise it returns 0. | |||
| "contents" | Contents of the upper-left cell. | |||
| "filename" | Filename of the file that contains reference. | |||
| "format" | Number format of the cell. See example formats below. | |||
| "parentheses" | Returns 1 if the cell is formatted with parentheses; Otherwise, it returns 0. | |||
| "prefix" | Label prefix for the cell. | |||
| * Returns a single quote (') if the cell is left-aligned. | ||||
| * Returns a double quote (") if the cell is right-aligned. | ||||
| * Returns a caret (^) if the cell is center-aligned. | ||||
| * Returns a back slash (\) if the cell is fill-aligned. | ||||
| * Returns an empty text value for all others. | ||||
| "protect" | Returns 1 if the cell is locked. Returns 0 if the cell is not locked. | |||
| "row" | Row number of the cell. | |||
| "type" | Returns "b" if the cell is empty. | |||
| Returns "l" if the cell contains a text constant. | ||||
| Returns "v" for all others. | ||||
| "widtth" | Column widtth of the cell, rounded to the nearest integer. | |||
| Commonly used types are in yellow | ||||
| I generally use below function to get to know at which location this file is saved and get the full syntex of the same | ||||
| D:\Personal\PRAKASH\CACLUB\[30FN30D - CELL Function.xlsx]TRIM | ||||
| You can copy this syntex. | ||||
CAclubindia
