Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Declaring variables dans Excel Cells

ayi

Is it possible to declare variables in Excel cells and use them as parameters for formulas in other cells?
For example I would declare <code>var1=10</code> in one of the cells. 
In another cell I would use <code>var1</code> for calculation like: <code>=var1*20</code>.

ayi_2

You can name cells. This is done by clicking the Name Box (that thing next to the formula bar which says “A1” for example) and typing a name, such as, “myvar”. Now you can use that name instead of the cell reference:
<pre><code class="lang-auto">= myvar*25

</code></pre>