Cell reference math

A

Adam__

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!
 
E

Elkar

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
 
M

Marcelo

Hi Adam

try =indirect("A"&(12=5))

HTH
Regards from Brazil
Marcelo

"Adam__" escreveu:
 
A

Adam__

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
 
Top