mark

You cannot. Formulas can only return results to the cell in which they are
written.

You must have a formula also in the cell in which you would like to see the
result.

Something like =A1 where A1 is the cell with original formula.

OR skip the A1 part and write your formula in the results-to-be-seen cell.


Gord Dibben Excel MVP

On Sun, 7 Aug 2005 11:40:01 -0700, "mark"
wrote:

how to put a formula in one cell and the result in a another cell