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