formula display

K

Kari

Is there any way to display the results of a formula in a
cell other than the one where the formula is located?
 
C

Chip Pearson

Kari,

A formula can only return a value to the cell from which it was
called. It cannot modify the contents of any other cell, so the
answer is "no".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
 
S

Steve Kay

-----Original Message-----
Is there any way to display the results of a formula in a
cell other than the one where the formula is located?
.
Click to expand...

You could run the formula say out of the way.. or down the
say BB1 cell and post the answer in BB2. The redirect the
cell you wish to have the answer (say A1) to BB2.
 
Top