CELLCALC Function

The CELLCALC function returns the calculation of the current cell as a string into the current cell.

Syntax

CELLCALC(<cell number>)

If a cell number is specified, it returns the cell calculation 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 calculation of the current cell.

Example 1

Enter CELLCALC() in a cell and it returns CELLCALC().

Example 2

Enter CELLCALC(ABC.D3) returns the cell calculation of cell ABC.D3. For example if cell ABC.D3 had a cell calculation of "GRP("1","100","BA")", returns "GRP("1","100","BA")".

Related Topics