• Miscellaneous Functions
  • Miscellaneous Functions
  • BROWSTAT function
  • CELLCALC function
  • CELLCOL function
  • CELLLABEL function
  • CELLNO function
  • CELLROW function
  • CELLSTR function
  • CELLTABLE function
  • CUSTPROP function
  • CUSTPROPAT Function
  • CUSTPROPR function
  • CVDATA function
  • CVDATAC function
  • CVDATAL function
  • CVDATALNG function
  • CVDATAQRY function
  • CVDOCPOS function
  • CVFORM function
  • CVGROUP function
  • CVINFO function
  • CVMENUST Function
  • DOCID function
  • DOCMODE function
  • EVAL function
  • GETHIDE function
  • INITIALS function
  • ISCONS function
  • ISINGROUP function
  • ISINGRP function
  • KLIEXIST function
  • KLIPROP function
  • KLLPROP function
  • LEVEL function
  • LOOKUP function
  • MKPATH function
  • RDYREVIEW Function
  • REPENT function
  • SCRNX function
  • SCRNY function
  • WHOAMI function

CELLLABEL Function

The CELLLABEL function returns the cell label of the current cell as a string into the current cell.

Syntax

CELLLABEL(<cell number>)

If a cell number is specified, it returns the cell label of that cell as a string. This reference must be a direct cell reference. If a cell is not identified, then the function returns the cell label of the current cell.

Example 1

Enter CELLLABEL() in a cell with a cell label "Year end Calculation", returns "Year end Calculation".

Example 2

Enter CELLLABEL(ABC.D3) returns the cell label of cell ABC.D3. If that cell has no label, the function returns an empty cell. If the cell label is a function, then CELLLABEL() returns the results of that function.

 

Note:

Cell labels on the General tab in Edit Cell Properties do not support dependencies.

• Example: If C1 has CELLLABEL(C2) function and C2 cell label refers to C3, then any changes in C3 will not automatically recalculate in C1.
• Solution: If you are working with cells that depend on other cells to recalculate, consider using custom properties instead.

Related Topics

• Miscellaneous Functions