This is a semifunction - it can only be used in Name Manager.
This is how you can use it:
- you point to a cell and you open Name Manager
- then you write
=evaluate( and click on the cell you want [best to keep relative reference]
- you finish the formula with
- you give it a NAME - [in this example I'll just call it
- you click OK
Now, let's suppose that you've selected B1 and made all this refer to A1.
In A1 you can put "1+1" and in B1 you write
=eva - once you've hit ENTER, the B1 value will be
As the reference in Name Manager was relative, you can use
=eva to get the evaluation of any cell one cell left from where you want it. (eg. in B2,
=eva will return the result of cell A2)