Make a results cell Non-dependent on the other Cells 1

[mcbigj]

I want to know, can I make a results cell data "Stick" so that once the calculation from the other cells is done (e.g E3 = E1 + E2) they can be deleted.
So I would want the result in E3 to stay even if E1 & E2 were deleted. Is this possible?
Thanks.

 

[Davefeet]

Well what I do is create another column and take the column from the formula, say copy, and when you paste it into the new column that you just inserted, right click and say paste special, under paste special click on value, and then you can delete columns E1,2, and 3.

 

[mcbigj]

thanks. I'll give it a go.

 

[acron]

You can also just Copy column E, and PasteSpecial, Values over itself.

AC

 

[euskadi]

You can also do this. Enter your data in e1 and e2, then enter your equation in e3 like this replacing "e1+e2" with the calculation you want to do.

=IF(AND(E1="",E2="&quot,E3,E1+E2)

Then select tools/options/calculation and check the Iteration box and allow 1 iteration.

If you change the data in E1 and E2 the value in E3 will change, but if you select both cells and delete them, the value in E3 will persist.

Probably not what you're looking for, but it does accomplish what you asked.

 

[mcbigj]

Thanks for all of that. YOu really helped me out.