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
sub-menu from the menu.See also: