Copy formula so destination displays formula as text
 

Cell C123 contains the value 99.

I want cell A1 to display that value (99) and cell B1 to display the formula
(=C123).
I put =C123 in cell A1. What do I put in cell B1?

I know I can toggle between value and formula but how do I get them to both
display side-by-side at once?

THANK YOU!

Here is a UDF solution that will work:

Function GetFormula(Cell)
GetFormula = Cell.Formula
End Function

Then in B1 enter =GetFormula(C123)


--
Regards,
Dave


"Omunene" wrote:

Cell C123 contains the value 99.

I want cell A1 to display that value (99) and cell B1 to display the formula
(=C123).
I put =C123 in cell A1. What do I put in cell B1?

I know I can toggle between value and formula but how do I get them to both
display side-by-side at once?

THANK YOU!

THANKS DAVE!


"David Billigmeier" wrote:

Here is a UDF solution that will work:

Function GetFormula(Cell)
GetFormula = Cell.Formula
End Function

Then in B1 enter =GetFormula(C123)


--
Regards,
Dave


"Omunene" wrote:

Cell C123 contains the value 99.

I want cell A1 to display that value (99) and cell B1 to display the formula
(=C123).
I put =C123 in cell A1. What do I put in cell B1?

I know I can toggle between value and formula but how do I get them to both
display side-by-side at once?

THANK YOU!