Omitting the reference argument does not reliably produce information about a specific cell, for the following reasons: Important: Although technically reference is optional, including it in your formula is encouraged, unless you understand the effect its absence has on your formula result and want that effect in place. If the reference argument is a range of cells, the CELL function returns the information for active cell in the selected range. If omitted, the information specified in the info_type argument is returned for cell selected at the time of calculation. The cell that you want information about. The following list shows the possible values of the Info_type argument and the corresponding results. The CELL function syntax has the following arguments:Ī text value that specifies what type of cell information you want to return. If it is important for others to open your workbook using different language versions of Excel, consider either using alternative functions or allowing others to save local copies in which they revise the CELL arguments to match their language. For example, if you create a formula containing CELL while using the Czech version of Excel, that formula will return an error if the workbook is opened using the French version. Note: Formulas that use CELL have language-specific argument values and will return errors if calculated using a different language version of Excel.
