Cell reference math

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Can anyone help me with the syntax for doing cell reference math? I want
to write a formula which adds a number to another cells row index.
I.E. In any cell write: A12+5 = A17, therefore referencing contents of
A17. What is the simplest way to do this?

Thanks in advance!
 
I'm not sure I understand exactly what you're trying to do. A formula can
only return a value to the cell that it is placed in.

=A12+5=A17

Entering this formula into any cell (except A12 and A17) will return either
TRUE or FALSE. Is this what you're looking for? Or are you trying to assign
a value to either A12 or A17 from a different cell? If so, you'll need to do
that from within A12 and/or A17. Please provide more details if you need
further help.

HTH,
Elkar
 
Thanks to you and others who responded. That seems to work. So does the
indirect method, but this one is a bit shorter, which is important since some
of the formula's that I am using can get pretty long.

Adam
 
Back
Top