Forum Discussion
Securing the value in a cell
Hi! Say I have a small shop at a sports stadium, and want to calculate profits on each product I sell for the season. The way I've done it is having three sheets; 'sales', 'cost' and 'resul...
Thanks!
I hoped it could be as easy as to lock some cells so they wouldn't be updated, but dreaded the solution would be complicated.
Thank you so much for the answer, I'll try it out!
If you are ok with locking cells, you can always save your formula in a cell (just add a single quote in front of it) set the cost for the first half of the season, copy the relevant cells and past values so they will no longer calculate, then update your cost to the next value and the formulas calculate until the next cost change. There are many ways to adjust the formula to not require a workaround like this, but it will do if you are dealing with data that really doesn't change except for the addition of new information in the existing structure.