CELL function - The function returns information about the format or content of a cell in Excel
The following article introduces you to the CELL function - one of the functions in the information function group is very popular in Excel.
CELL function - The function returns information about the format or content of a cell in Excel Picture 1
Description: The function returns information about the format or content of a cell.
Syntax: CELL (info_type, [reference])
Inside:
- info_type: Text value that determines the type of information returned, is a required parameter. Types of information returned:
+ info_type = address -> returns the address of the cell.
+ info_type = col -> returns the column number of the cell.
+ info_type = color -> returns the color of the cell.
+ info_type = contents -> returns the content of the cell.
+ info_type = filename -> returns the name including the full path.
+ info_type = format -> returns the format of the cell.
+ info_type = parentheses -> identify cells that use single quotes for positive values or all values, otherwise return 0.
+ info_type = prefix -> returns the cell label prefix.
+ info_type = protect -> determines if the cell is locked or not if it returns 1 value otherwise returns 0 value.
+ info_type = row -> returns the number of rows of the cell.
+ info_type = type -> returns the cell's data type.
+ info_type = width -> returns the width of the cell.
- reference: The cell that wants to return the corresponding information, which is an optional parameter if omitting the function that returns information for the last cell.
Attention:
- In case you change the format of a cell but then set another format -> must reset that sheet.
For example:
Determine the information of the cells described in the following data table:
CELL function - The function returns information about the format or content of a cell in Excel Picture 2
- Define information about the number of rows of cells. In a cell to calculate enter the formula : = CELL ("row", C6)
CELL function - The function returns information about the format or content of a cell in Excel Picture 3
- Press Enter -> return value is:
CELL function - The function returns information about the format or content of a cell in Excel Picture 4
- Similarly determine the data type of the cell -> enter the formula: = CELL ("type", C7) -> press Enter -> return value is:
CELL function - The function returns information about the format or content of a cell in Excel Picture 5
- Determine the content of the cell -> enter the formula: = CELL ("contents", C8) -> press Enter -> return value is:
CELL function - The function returns information about the format or content of a cell in Excel Picture 6
- Similarly determine the format and address of the cell (corresponding format and type ) -> the results:
CELL function - The function returns information about the format or content of a cell in Excel Picture 7
Above are instructions and some specific examples when using CELL function in Excel.
Good luck!
You should read it
- CELL function to look up information of a cell in Excel
- ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel
- How to use ADDRESS function in Excel
- Function Address - The function returns the address of a cell in Excel (usage, examples, examples)
- ISBLANK function - The function checks if a cell is a blank value in Excel
- How to insert comments in Excel
- Turn off turn on the character repeat function in Excel
- How to use the Match function in Excel
- DCOUNTA function, how to use the function to count non-empty cells in Excel
- The Match function (the function searches for a specified value in an array or cell range) in Excel
- How to use COUNTIF function on Excel
- The COUNTIFS function, how to use the cell count function according to multiple events in Excel
May be interested
ERROR.TYPE function - The function returns the number corresponding to one of the error values in Microsoft Excel
INFO function - The function returns the current operating environment information in Excel
NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel
NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel
NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel
PEARSON function - The function returns the Pearson product moment correlation coefficient in Excel