- Picture and text skills
- Case
Returns information such as the format, location, or content of the upper-left corner cell of a reference range.
Syntax
CELL(info_type,reference)
Info_type A text value that specifies the type of cell information required. Possible values for info_type and their corresponding results are listed below.
Reference Represents the cell about which information is to be obtained. If omitted, the information specified in info_type will be returned to the last changed cell.
The following table describes the text values returned by the CELL function when the info_type is "format" and the reference is a cell formatted with the built-in number format.
If the info_type parameter in the CELL formula is "format" and the cell is later set with a custom format, the worksheet must be recalculated
to update the CELL formula.
Description
Function CELL is used for compatibility with other spreadsheet programs.
The example may be easier to understand if you copy it into a blank worksheet.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/chao-ji-shen-mi-de-CELL-han-shu.html
评论列表(196条)
测试