If your goal is to see both the formula and the result at the same time, then
do as follows:
Enter the formula normally in the cell to display the result of the
calculation.
Enter the formula without the leading "=" to display the details of the
calculation in another cell.
--
Gary's Student
"mark" wrote:
how to put a formula in one cell and the result in a another cell
|