K Kari Aug 13, 2003 #1 Is there any way to display the results of a formula in a cell other than the one where the formula is located?
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 Aug 13, 2003 #2 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)
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)
S Steve Kay Aug 13, 2003 #3 -----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.
-----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.
