copy formula

[engrav]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I would like a function to say
if O2 = 1
go to T2 and get the formula therein and
paste it into P2 making the references correct for P2
how do I do that?
thank you

 

[CyberTaz]

You can't use a formula to change the references in another formula which is
what it sounds like you're describing. Please provide something more
explicit about exactly what you want to achieve.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I would like a function to say
if O2 = 1
go to T2 and get the formula therein and
paste it into P2 making the references correct for P2
how do I do that?
thank you

I'm not sure I understand what you're going after, exactly, but formulae
can only return values to their calling cells, they can't put something
into a different cell.

If I do understand you correctly, you can put this in P2

=IF(O2=1, T2, "")

which, if O2=1, will display the *value* in T2 in cell P2, otherwise it
will display a blank/null string.