displaying formula results in different cell.
 

I have a formula in a range of cells that give the result in the same cell
the formula has been typed in, but l want to display the result in a
different cell. Is this possible and how would l do this?
--
Thanks,
Gary.

displaying formula results in different cell.
 

If you have a formula in cell A1 and want to display the results in cell
Z100, then in Z100 enter:
=A1
--
Gary's Student


"Gazza" wrote:

I have a formula in a range of cells that give the result in the same cell
the formula has been typed in, but l want to display the result in a
different cell. Is this possible and how would l do this?
--
Thanks,
Gary.