Result of a formula in another cell
 

Although I'm suspecting this cannot be done, generally, Excel surprises me
with neat tricks and tools. So, that's why I'm asking, since I haven't found
a way . . .

I have a value in a cell. In the next column, I have an If/then formula to
check the first cell's value.

Is there a way to change the value of the first cell with the formula in the
second cell? (Fail that, I'll use VBA.)

Thanks for any info.

Rich

Result of a formula in another cell
 

Nope, not unless the first one has an if then that checks the other column,
circular reference style. So no, not really.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Rich W." wrote:

Although I'm suspecting this cannot be done, generally, Excel surprises me
with neat tricks and tools. So, that's why I'm asking, since I haven't found
a way . . .

I have a value in a cell. In the next column, I have an If/then formula to
check the first cell's value.

Is there a way to change the value of the first cell with the formula in the
second cell? (Fail that, I'll use VBA.)

Thanks for any info.

Rich

Result of a formula in another cell
 

Thanks John . . .

Just after I posted the question, I thought of that too. It would be
recursive.

Thanks again . . .

Rich

"John Bundy" wrote:

Nope, not unless the first one has an if then that checks the other column,
circular reference style. So no, not really.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Rich W." wrote:

Although I'm suspecting this cannot be done, generally, Excel surprises me
with neat tricks and tools. So, that's why I'm asking, since I haven't found
a way . . .

I have a value in a cell. In the next column, I have an If/then formula to
check the first cell's value.

Is there a way to change the value of the first cell with the formula in the
second cell? (Fail that, I'll use VBA.)

Thanks for any info.

Rich