You need the formula to be =B10/C10 without names
You will have to type this rather that build it by pointing since pointing
always picks up names
Then you can copy it down the column
Are you using the name for something else? If not then Insert | Names |
Define | Delete
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"G.R. Toro" wrote in message
m...
Here is my question (BTW, I am using Excel 2003):

I have a table of values, and I have given each column in the table a name
(created with Insert|Name|Define). For instance, these names may be
something like

Price | Weight | Volume | Age | etc., beginning at address A10
100 | 3 | 10 | 6 |
20 | 5 | 7 | 1 |


Now, I want to create a new column with values derived from the values in
this table. The difficulty is that I would like to have the formula (for
instance, =Weight/Volume) in one place only (say, cell B1), in such as way
that I can change the formula in B1 and cause the change to propagate to
the entire new column of my table.

In essence, what I would like is a function that says: evaluate the
formula in $B$1 as if that formula had been written in the current cell.
It's something like =offset($b$1,0,0) or =indirect("$B$1"), but for
formulas involving Names.

Any suggestions would be greatly appreciated.

Thanks,

Gabriel