How do I lock cell value even if other values change

L

Loraise

How do I lock cell value even if the number that created the cell value
change? I am trying to make excel calculate a midterm grade. That value
would remain frozen while the overall grade changes.

Example

December 15/05
Subject A = 74
Subject B = 69
Midterm Grade is (74+69)/2 - This value would be locked or frozen

June 23/06
Subject A = 81
Subject B = 77
Midterm Grade is (74+69)/2 - from previous calculation because it was locked
Final Grade (81+77)/2

So far I have tried to use expressions like $G$3

Subject A Subject B Midterm Final
74 69 71.5

but whenever I change the values in Subject A or B, the value in Midterm
changes also.

Please help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return a value from a table using Column and row names as input? 8
Help? SUM row to a cell with a specific value in a different row 4
Need to determine where a change in table occurs 6
formula reference~muliple sheets 9
Validation rules base on formula on other cell 0
How to use VLookup with a range of numbers? 3
EZ Q 4 U: How do I change a number to text, based on the number 2
Can I lock a cell after data entry so entry can not be changed 3

Top