Numbers is a cell being used in a formula
Is there a way to determine if a cell is being used in a formula someplace in a spreadsheet?
Is there a way to determine if a cell is being used in a formula someplace in a spreadsheet?
Hi MD_Gene,
sorry but unfortunately that is not possible in Numbers.
I know this is available in Excel, maybe others have it too.
But as soon as you select a cell with a formula it will show you what cells are use in this formula.
Regards Ralf
Hi MD_Gene,
sorry but unfortunately that is not possible in Numbers.
I know this is available in Excel, maybe others have it too.
But as soon as you select a cell with a formula it will show you what cells are use in this formula.
Regards Ralf
An easy way to tell is to temporarily introduce an error into the cell. I often just divide by 0.
If you see red warning triangles in other cells then you know they depend on that cell.
SG
Numbers is a cell being used in a formula