MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Change a Cell Value without Changing the Formula


May 17, 2002 - by Juan Pablo Gonzalez

Michael (Another one!) asks:

Can I change a cell value without changing the formula?

Well... No. I mean, if you have in a cell

=1+2

The result will Always be 3. You can’t change the value to “4” without replacing or changing the formula.