Cell reference math

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

 

[Dana DeLouis]

I.E. In any cell write: A12+5 = A17, therefore referencing contents of

A17.

Here's one way: =OFFSET(A12,5,0)

 

[Guest]

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

 

[Guest]

Hi Adam

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

HTH
Regards from Brazil
Marcelo

"Adam__" escreveu:

 

[Guest]

sory change "=" --> "+"

"Marcelo" escreveu:

Hi Adam

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

HTH
Regards from Brazil
Marcelo

"Adam__" escreveu:

 

[Guest]

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

 

[Guest]

The indirect formula works great... similar application, great result!

Thanks,