I'm very new to excel and i think i just don't understand a basic function
but i couldn't find it under the help menu.
how can you define a cell using a letter and then a value of another cell?
here is an example
W15=5
D5=10
my guess was =D(W15) which i would like to equal 10, but i get a name error
Hi Todd
Try
=INDIRECT(quot;Dquot;amp;W15)
--
Regards
Roger Govier
Todd Duncombe lt;Todd gt; wrote:
gt; I'm very new to excel and i think i just don't understand a basic
gt; function but i couldn't find it under the help menu.
gt;
gt; how can you define a cell using a letter and then a value of another
gt; cell? here is an example
gt; W15=5
gt; D5=10
gt; my guess was =D(W15) which i would like to equal 10, but i get a name
gt; error
- Aug 07 Thu 2008 20:45
define a cell with the value of anothe cell
close
全站熱搜
留言列表
發表留言