View Single Post
  #5   Report Post  
Gary's Student
 
Posts: n/a
Default

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