Copy formula so destination displays formula as text

[Guest]

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!

 

[Guest]

Here is a UDF solution that will work:

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

Then in B1 enter =GetFormula(C123)

 

[Guest]

THANKS DAVE!

Here is a UDF solution that will work:

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

Then in B1 enter =GetFormula(C123)