PARENTCELL

This function is designed for working with data in row hierarchies.

Returns the value of the parent of the specified cell. If no cell is specified, the cell the function is called within is used as the reference.

Sample Usage

PARENTCELL()

PARENTCELL(A4)

Syntax

PARENTCELL(cell)

• cell - [OPTIONAL] The cell to use as a reference for retrieving its parent cell value. If no cell is provided, this function returns the parent cell value of the cell it is called from.

Examples

PARENTCELL() - returns the value in the current cell's parent cell.

PARENTCELL(A4) - returns the value in the parent cell of cell A4.

Notes

• PARENTCELL returns a single cell value.
• PARENTCELL will be recalculated on indent/outdent changes, create-row, delete-row actions.
• Unlike the ANCESTORCELLS function, PARENTCELL returns only the direct parent cell value of the specified cell.