Formula to show formula from another cell

[rodgersmg]

Hi all,

does such a formula exist? I regularly Change a formula in cell C1. To Show my working I would like to have The formula from C1 written next to it as an equation.


Example: B1 | C1
=Text"updated from formula in C1 automatically" | =x+y*A2

Summarised, is there a formula to Display the formula written in another cell?

Thanks in advance!

Michael

[Olly]

A small UDF will do this neatly.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[rodgersmg]

UDF it is then Thanks Olly!