abc MICROSOFT EXCEL 2010 - Iterations /ITERATIONS
Absolute adressing of the variables

Absolute adressing of the variables doesn't have to be used with all variables. An absolute adress contains a string $ by the adress >>.

Example of using EXCEL for calculating current velocity via a formula:
         

Absolute adressing of the variables, steps:

  1. Values v0 and g are input only once and are used as constants.
  2. The string $ is used for absolute adressing next to the row coordinate (in this particular case).
  3. The end (Kraj).

Index