Horizon Icon

Referencing Other Cells

You can use the value from one cell in the formula in another. Create a cell with a value in it. Now create a second cell and type the ‘equals’ sign to begin a formula. To reference the first cell, just click on it. The representation of the first cell is added to the formula.

Horizon colors the background of a cell reference in a formula to the same color as the category.

Formulas can reference any number of other cells, and referenced cells may also contain formulas. Results will update after any referenced cell is changed.

Cell Reference

See also

Using Relative References
Cell Topics