Home

"Freeze" results of a cell formula

%3CLINGO-SUB%20id%3D%22lingo-sub-550328%22%20slang%3D%22en-US%22%3E%22Freeze%22%20results%20of%20a%20cell%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550328%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20spreadsheet%20used%20to%20keep%20a%20log%20of%20a%20system's%20behavior.%20A%20cell%20in%20each%20log%20entry%20depends%20on%20a%20configuration%20variable%20that%20can%20be%20changed%20as%20time%20(days)%20go%20by.%20I%20would%20like%20each%20log%20entry%20to%20record%20the%20setting%20of%20that%20variable%20at%20the%20time%20the%20log%20entry%20was%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20put%20a%20formula%20in%20once%20cell%20of%20the%20log%20entry%20that%20captures%20the%20variable%2C%20and%20does%20not%20change%20as%20new%20log%20entries%20are%20made%3F%20The%20log%20table%20grows%20one%20row%20at%20a%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20I%20could%20do%20this%20programmatically%20with%20a%20macro%20but%20would%20prefer%20a%20non-macro%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I%20have%20expressed%20that%20clearly!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-550328%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-553560%22%20slang%3D%22en-US%22%3ERe%3A%20%22Freeze%22%20results%20of%20a%20cell%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-553560%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20I%20can%20state%20this%20more%20clearly...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20cause%20a%20cell%20with%20a%20formula%20to%20replace%20it's%20formula%20with%20the%20value%20resulting%20from%20the%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20I%20can%20cut%20and%20paste%20to%20make%20that%20happen%20but%20I%20don't%20want%20to%20go%20through%20those%20steps%20as%20they%20are%20error%20prone%20or%20easily%20skipped%20by%20mistake.%20Ideally%20it%20would%20happen%20automatically%2C%20perhaps%20as%20the%20date%20changes.%20Old%20entries%20would%20be%20frozen.%3C%2FP%3E%3C%2FLINGO-BODY%3E
bertilak
New Contributor

I have an excel spreadsheet used to keep a log of a system's behavior. A cell in each log entry depends on a configuration variable that can be changed as time (days) go by. I would like each log entry to record the setting of that variable at the time the log entry was created.

 

Is there a way to put a formula in once cell of the log entry that captures the variable, and does not change as new log entries are made? The log table grows one row at a time. 

 

I think I could do this programmatically with a macro but would prefer a non-macro solution.

 

I hope I have expressed that clearly!

1 Reply

I think I can state this more clearly...

 

Can I cause a cell with a formula to replace it's formula with the value resulting from the formula?

 

I know I can cut and paste to make that happen but I don't want to go through those steps as they are error prone or easily skipped by mistake. Ideally it would happen automatically, perhaps as the date changes. Old entries would be frozen.

Related Conversations
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies