naming question



hola,

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
equations.

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"?

pete



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