you will have to retype the formula in the other cell, and change the format
of one of them to text. Formulas can only affect the cells they are written
in.

"Susan" wrote:

I would like to show the formula of a calculation in one cell and the answer
in another. Do I have to retype as text? Or, is it possible to show both
simultaneously with just one formula? Is this possible?

Example, in cell A6 type =sum(A1:A5) and have the formula show in cell A6
and the answer to the formua in cell B6.