Are you looking for your function to return the text of the formula, or just
have the same formula?

If you just want both cells to have the same formula, just put $ in front of
both parts of your cell reference.
so, if the formula is =A2, change the formula to =$A$2. then, no matter
where you put it, it will return the same value.

"Edward" wrote:

What is the best way to return a cell's formula (using a function)?

I'm thinking along the lines of this (fictional) function:

=CELL("formula",A1)

TIA,

Ed