Identifying cells

[ronduke]

How do you identify unconnected cells in a Word Table to create an accurate
formula? I have a Table where not all cells are numerical, but broken up by
cells with text in them.

thanks,
ronduke

 

[Greg Maxey]

In formulas cells are referenced by an alpa-numberic index. A1 is the first
column first row. Z26 is the 26th column and 26th row

So if you wanted to add A1 to Z26 you would used {=(A1+Z26)}
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Greg Maxey - Word MVP

My web site http://gregmaxey.mvps.org
Word MVP web site http://word.mvps.org~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[ronduke]

Greg,
Thanks for responding. However, that doesn't answer my question. There are
no precise columns as the rows have differing numbers of cells, some text and
some currency and other numbers. With no clear cut columns, how do I
identify specific cells?

In formulas cells are referenced by an alpa-numberic index. A1 is the first
column first row. Z26 is the 26th column and 26th row

So if you wanted to add A1 to Z26 you would used {=(A1+Z26)}
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Greg Maxey - Word MVP

My web site http://gregmaxey.mvps.org
Word MVP web site http://word.mvps.org~~~~~~~~~~~~~~~...xt in them. thanks, ronduke[/QUOTE] [/QUOTE]