= Spreadsheet cell
An addressed entry of a <spreadsheet>, such as `A1`. Here it stores either a literal numerical <input> or a <spreadsheet formula>; its current value is distinct from the stored formula. A <cached cell value> records a previously computed value, not an instruction to compute it again.
In a <spreadsheet tabular model>, `D2` can store `=C2*(1+$F$1)` while displaying `9`. The <spreadsheet cell reference> `D2` identifies the location, the <spreadsheet formula> describes the calculation, and `9` is the value obtained from the present <inputs>. Keeping those three ideas distinct makes copying and checking a model much easier.
Back to article page