possibility to tell Excel to calculate is a crucial feature
and the most important reason to use it. In other demos
Peter Kalmstrom has shown how to
create formulas for plus and minus and
how to make Excel mulitpy and divide.
When you use a formula, Excel calculates with the values
of the cells you have specified in the formula and gives
the result in a separate cell. When the values in the cells
are changed, the figure in the result cell will change automatically.
In the demo below Peter shows how you can take values for
the calculation from another Excel sheet than the one where
you want the result to be displayed.
As an example Peter uses calculations on the prices for
three different kinds of ice cream. He has the ice cream
ingrediedients and their costs on one Excel sheet, and he
wants the cost per ice cream to go into another sheet where
he calculates what price to take for each kind of ice cream.
Peter uses Excel 2013 for his demo, but the formulas are
the same for earlier versions of Excel.
You might also be interested in reading the kalmstrom.com
Blog post about Excel formulas with references between sheets
and in studying the
Tip about the Excel lookup and data validation functions.