formula display

  • Thread starter Thread starter Kari
  • Start date Start date
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?
 
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 (e-mail address removed)
 
-----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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Cell reference in formula string displays abbreviated value 2
formula displays as a formula, not as its result 1
Why does forumula show in cell instead of formula result? 2
E2007 formulas display as formulas, not results 3
Counting Results of Formulas 1
Cell shows the last typed text, no matter where it is typed 0
VLOOKUP displays formula rather than result Excel 2007 2

Back
Top