Re: naming question

On Sun, Apr 14, 2002 at 11:02:28AM -0700, Peter Jay Salzman wrote:

i'd like to be able to name cells to make formulas easier to read.

suppose cell A1 contains 1.0 and i'd like name this cell "hbar" in

1. click on insert | name | define
2. in "name" place "hbar"
3. click on "expression" box, then click on cell A1.  this will place
   Sheet1!A1 in the expression box

how exactly do i use this name now?   i've tried:

hbar (gnumeric interprets this as a literal string)
=hbar (puts a zero in the cell)
"hbar" (another literal string)
=power(hbar,2)   (doesn't work either)

how do i make reference to the cell whose name is "hbar"?

The trick is that A1 is a relative reference.
Use $A$1.  This was both a requested feature, and an Excel
compatibility issue.

You can also quickly define a name by using the naming region in the
top left of the sheet.  Just select the region you want to name, and
enter the name there.

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]