Cell references

Once you have entered your data into number cells, you can build formulae which operate upon the data to produce results.

You don't need to type in your data all over again to include it in the formulae; instead, you enter a reference to the cell containing the data. When the formula is calculated, Fireworkz looks for the number stored in that cell, and uses that in the calculation. This allows you to build up chains of calculations, each operating on the result of the previous calculation; if you change some of the original data, all the calculations will be automatically updated to reflect the new starting data.

References are usually put in number cells, as part of formulae. It is also possible to enter cell references in text cells, using the Inserts sub-menu from the Extra menu.

See also:

Single cell references

Ranges

Absolute references

External references