I love spreadsheets but sometimes I think they are winning the battle when I try and extract a function from them. Help me control my spreadsheet.
Here is a sample of what I am trying to do.
[summary] I am trying to get a cell to reflect the a relationship between two numbers in a column. So in other words, I am needing a dynamic cell to reflect when a new number is added to the column.
Currently B11 =B4-B10 (B10 is "goal")
If I enter a value in B5 then I would like the value in B11 to change to reflect that. Then later, when I add a value to B6 the value in B11 then reflect that cell. So on and so forth.
I wish I could actually post a short version of that here but I don't see how.